Re: [HACKERS] FROM clause omitted

2003-07-16 Thread Bruno Wolff III
On Wed, Jul 16, 2003 at 08:29:01 +0200, Dennis Björklund <[EMAIL PROTECTED]> wrote: > I had a bug in one of my queries that wasn't detected by pg because if > filled in the from clause by itself. Take for example a querie like Currently this is the only way to use additional tables when doing a

Re: [HACKERS] FROM clause omitted

2003-07-16 Thread Christoph Haller
> > I had a bug in one of my queries that wasn't detected by pg because if > filled in the from clause by itself. Take for example a querie like > > select foo.a; > > which I guess is transformed to > > select foo.a > from foo; > > Is this really a good thing to do? Is it part of the standard? Can

Re: [HACKERS] FROM clause omitted

2003-07-16 Thread Rod Taylor
> Is this really a good thing to do? Is it part of the standard? Can it be > turned of? In my case it hid a bug and made my query work but produce the > wrong result. 7.4 has a switch to turn this off for the same reasons you cite. signature.asc Description: This is a digitally signed message pa

[HACKERS] FROM clause omitted

2003-07-16 Thread Dennis Björklund
I had a bug in one of my queries that wasn't detected by pg because if filled in the from clause by itself. Take for example a querie like select foo.a; which I guess is transformed to select foo.a from foo; Is this really a good thing to do? Is it part of the standard? Can it be turned of? In