Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2224: unlogical syntax error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2224: unlogical syntax error
Date
Msg-id 5330.1138634388@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2224: unlogical syntax error  ("Hervé Hénoch" <h.henoch@isc84.org>)
List pgsql-bugs
Tree view 
"Hervé Hénoch" <h.henoch@isc84.org> writes:
> CETLOG:  statement: PREPARE <unnamed> AS SELECT adm_pat."nip", id_caisse
> caisse FROM adm_pat  WHERE nip = '20020523'

> CETERROR:  syntax error at or near "caisse" at character 33

"AS" before a column alias is not optional in Postgres.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [PATCHES] BUG #2221: Bad delimiters allowed in COPY ...
Next
From: Philipp Reisner
Date:
Subject: Endless loop in ExecNestLoop