PostgreSQL 9.6.17 COALESCE function error

0 votes

1 answer

925 views

postgresql postgresql-9.3 postgresql-9.6 type-conversion coalesce

                          I'm trying a SQL query with the function COALESCE in PostgreSQL 9.6.17, but it produces an error:

> invalid syntax for type double precision: ""

Example query: 

    SELECT COALESCE(date_part('year', s.date_pp),'')
    FROM public.sendoc s.

This query is working on PostgreSQL 9.3.17.

How to get around the error at the server DB level without changing the source code of the program?

Asked by Иван Линюшин (1 rep)

Sep 7, 2020, 02:14 PM
Last activity: Sep 7, 2020, 10:32 PM

PostgreSQL 9.6.17 COALESCE function error

Related Questions