Re: [GENERAL] Bug or stupidity

2004-10-23 Thread Philip Hofstetter
Hi, Martijn van Oosterhout wrote: popscan_light=> select aliasa.name, aliasb.name2 from a aliasa left join b aliasb using (id) order by b.name2; NOTICE: adding missing FROM-clause entry for table "b" name | name2 ---+--- gnegg | gnegglink blepp | blepplink gnegg | gnegglink blepp |

[GENERAL] Bug or stupidity

2004-10-23 Thread Philip Hofstetter
Hello, I think, I found a bug, but maybe it's just my stupidity. Granted: What I did was an error on my part, but I still think, PostgreSQL should not do what it does. I've already created a simple testcase: popscan_light=> create table a (id serial, name varchar(10), primary key(id)) without o