Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Mladen GogalaDate: 2010-06-05 12:42:44
Subject: Re: Program Syntax Help Needed
Previous:From: Tom LaneDate: 2010-06-04 20:16:16
Subject: Re: Program Syntax Help Needed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group