Re: Program Syntax Help Needed

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Program Syntax Help Needed
Date: 2010-06-05 08:22:51
Message-ID: 201006051022.51399.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2010-06-05 12:42:44 Re: Program Syntax Help Needed
Previous Message Tom Lane 2010-06-04 20:16:16 Re: Program Syntax Help Needed