Re: [HACKERS] Re: [BUGS] Join/table alias bug

2000-09-29 Thread Bruce Momjian
Yes, this is what was eventually done... only emit warnings for tables already in the RTE, as Tom mentioned. > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > ... The reason this behaves that way is because queries > > without from lists (SELECT my_tbl.a) are valid in PostgreSQL for > > histori

Re: [HACKERS] Re: [BUGS] Join/table alias bug

2000-04-21 Thread Peter Eisentraut
Tom Lane writes: > Not only for historical reasons: there are cases where it allows you > to do things you couldn't easily do otherwise. An example is deleting > using a join: > > DELETE FROM target WHERE field1 = source.field2 Wow, that seems pretty bogus to me. > Bruce had actually pu