Re: [GENERAL] select t.name from tbl t (where name is not a column name)

Joe, What PG version are running? 8.2 here complains when running your example: ERROR: column foo.name does not exist LINE 6: select foo.name from foo; ^ ** Error ** ERROR: column foo.name does not exist SQL state: 42703 Igor Neyman -Original

Re: [GENERAL] select t.name from tbl t (where name is not a column name)

On 02/24/2010 07:16 AM, Igor Neyman wrote: Joe, What PG version are running? 8.2 here complains when running your example: ERROR: column foo.name does not exist LINE 6: select foo.name from foo; ^ ** Error ** ERROR: column foo.name does not exist

[GENERAL] select t.name from tbl t (where name is not a column name)

hi, i've just noticed the following behaviour and was wondering if there's any documentation to explain what it's for. create table tbl(id serial primary key, a text, b text, c text); insert into tbl(a, b, c) values ('abc', 'def', 'ghi'); insert into tbl(a, b, c) values ('jkl', 'mno',

Re: [GENERAL] select t.name from tbl t (where name is not a column name)

On 02/23/2010 05:07 PM, raf wrote: i've just noticed the following behaviour and was wondering if there's any documentation to explain what it's for. create table tbl(id serial primary key, a text, b text, c text); insert into tbl(a, b, c) values ('abc', 'def', 'ghi'); insert into