Postgres Pro
Downloads
Home   >   mailing lists

Re: Program Syntax Help Needed - Mailing list pgsql-novice

From Leif Biberg Kristensen
Subject Re: Program Syntax Help Needed
Date
Msg-id 201006051022.51399.leif@solumslekt.org
Whole thread Raw
In response to Program Syntax Help Needed  (Alan Simon <simon@hslc.org>)
List pgsql-novice
Tree view 
On Tuesday 27. April 2010 17.51.44 Alan Simon wrote:
>         JOIN staging_item_notes in
>         ON (b.id = in.bibkey)
>     WHERE in.bibkey != 0

You can't use "in" as an unquoted name, as that is a word with a special
meaning in SQL.

regards,
--
Leif Biberg Kristensen
http://solumslekt.org/blog/

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Program Syntax Help Needed
Next
From: Mladen Gogala
Date:
Subject: Re: Program Syntax Help Needed