brian wrote: > The following bug has been logged online: > > Bug reference: 4618 > Logged by: brian > Email address: b4kra...@yahoo.com > PostgreSQL version: 8.3.5 build1400 > Operating system: windows xp > Description: nolock changes first column name of query result set to > 'nolock' > Details: > > query1 works fine, first column in table is called movieid1: > select * from netflix.ratings where movieid = 1 > > > > > query2 is a bug and should work just fine, but gives error: > ERROR: column "movieid" does not exist > LINE 2: select * from netflix.ratings with (nolock) where movieid = ...
I don't know where you got "with (nolock)" from, but that's not PostgreSQL syntax - and AFAIK it's not standard SQL at all. Just remove it and you should be fine. //Magnus -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
