Re: syntax pb

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tuesday, May 30, 2023, Marc Millas <marc.millas@xxxxxxxxxx> wrote:

I get:

ERROR:  column "d" is of type numeric but _expression_ is of type text
LINE 2: Select distinct test1.t, 'abc' as b, NULL as c, NULL as d
                                                   
HINT:  You will need to rewrite or cast the _expression_.

Can someone give a short SQL syntax hint ?

https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-TYPE-CASTS

David J.