On Tue, May 30, 2023 at 3:51 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
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 ?
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.
