Odd "operator does not exist" message
Stumbled across this and it just seemed unusual - though by no means
cryptic.
SELECT 'text' || AS label
ERROR: operator does not exist: unknown ||
The lack of a second type to the right of the operator symbol caught my
attention.
SELECT 1 + AS label
ERROR: syntax error at or near "AS"
Was seemingly what I had been expecting...
David J.
"David G. Johnston" <david.g.johnston@gmail.com> writes:
Stumbled across this and it just seemed unusual - though by no means
cryptic.
SELECT 'text' || AS label
ERROR: operator does not exist: unknown ||
The lack of a second type to the right of the operator symbol caught my
attention.
SELECT 1 + AS label
ERROR: syntax error at or near "AS"
Was seemingly what I had been expecting...
|| is allowed as a postfix operator, + is not ...
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs