Marc MILLAS Senior Architect +33607850334 www.mokadb.com
On Tue, May 30, 2023 at 3:51 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, May 30, 2023, Marc Millas <marc.mil...@mokadb.com> 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 > I plainly agree on that... but its NOT what's happeninng. The doc you point to states: "An explicit type cast can usually be omitted if there is no ambiguity as to the type that a value expression must produce (for example, when it is assigned to a table column);" in the SQL I provide I ask to put a NULL in a numeric column. Can you tell where the ambiguity is ? > > David J. >
