[Please copy the mailing list on replies.]
On Tue, Jan 31, 2006 at 08:53:44AM +0100, Hnoch Herv wrote:
> Thank for you response I have never written this query : I think it
> is JDBC that have generated it ... My query (written by me) is :
>
>select id_caisse as caisse from FROM adm_pat
On Mon, Jan 30, 2006 at 10:47:10AM +, Herv Hnoch wrote:
> CETLOG: statement: PREPARE AS SELECT adm_pat."nip", id_caisse
> caisse FROM adm_pat WHERE nip = '20020523'
>
> CETERROR: syntax error at or near "caisse" at character 33
Are you writing this query or is JDBC generating it? The AS
"Hervé Hénoch" <[EMAIL PROTECTED]> writes:
> CETLOG: statement: PREPARE 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.
The following bug has been logged online:
Bug reference: 2224
Logged by: Hervé Hénoch
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Linux FC4
Description:unlogical syntax error
Details:
I do this request :
select id_caisse as caisse
