Postgres Pro
Downloads
Home   >   mailing lists

Re: syntax pb - Mailing list pgsql-general

From David G. Johnston
Subject Re: syntax pb
Date
Msg-id CAKFQuwYYvQQ0PCh3jQJdDKGha4wuTfCpBBj5m_AxioKgLP5PPg@mail.gmail.com
Whole thread Raw
In response to syntax pb  (Marc Millas <marc.millas@mokadb.com>)
Responses Re: syntax pb  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
Tree view
On Tuesday, May 30, 2023, Marc Millas <marc.millas@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 ?


David J. 

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: syntax pb
Next
From: Ray O'Donnell
Date:
Subject: Re: syntax pb