Odd "operator does not exist" message - Mailing list pgsql-bugs

From David G. Johnston
Subject Odd "operator does not exist" message
Date
Msg-id CAKFQuwa25zVF7y3ZUUXRvTeoGi7+MgpFGEObrQu5-DtgtLgNFQ@mail.gmail.com
Whole thread Raw
Responses Re: Odd "operator does not exist" message
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #13594: pg_ctl.exe redirects stderr to Windows Events Log if stderr is redirected to pipe
Next
From: Tom Lane
Date:
Subject: Re: Odd "operator does not exist" message