Odd "operator does not exist" message

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Odd "operator does not exist" message
Date: 2016-01-09 01:57:36
Message-ID: CAKFQuwa25zVF7y3ZUUXRvTeoGi7+MgpFGEObrQu5-DtgtLgNFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-01-09 05:09:39 Re: Odd "operator does not exist" message
Previous Message Michael Paquier 2016-01-08 23:04:25 Re: BUG #13594: pg_ctl.exe redirects stderr to Windows Events Log if stderr is redirected to pipe