Re: [BUGS] select clause not according to SQL standard

2005-02-25 Thread Richard Huxton
Klaus Ita wrote: Hi Richard! burn me, damn me! thank you. it is now working and i will sit back and read some more of the conf-options. It catches lots of people out. Helpful sometimes, but mostly I spend time puzzling just like you did. you just gave me a huge argument for the db and so i will p

Re: [BUGS] select clause not according to SQL standard

2005-02-25 Thread Klaus Ita
most conforming db. thx, klaus * Richard Huxton [2005-02-25 15:43: > From: Richard Huxton > Subject: Re: [BUGS] select clause not according to SQL standard > To: Klaus Ita <[EMAIL PROTECTED]> > Cc: pgsql-bugs@postgresql.org > X-Virus-Scanned: by Amavis (ClamAV) at st

Re: [BUGS] select clause not according to SQL standard

2005-02-25 Thread Richard Huxton
Klaus Ita wrote: i have the following data: table L: LNR ORT LCODE MENGE L1 GrazA 1000 L2 WienC 500 L3 WienC 1500 L4 LinzB 1000 L5 GrazB 300 table P: PNR PNAME ORT PREIS P1 Alpha Wien50.00 P2