Re: select clause not according to SQL standard

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.

you just gave me a huge argument for the db and so i will probably win
my fight against a stubborn professor, that wants to stick to his big
fat o....e 'cause it is the most conforming db.

thx,
klaus

* Richard Huxton <dev(at)archonet(dot)com> [2005-02-25 15:43:

> From: Richard Huxton <dev(at)archonet(dot)com>
> Subject: Re: [BUGS] select clause not according to SQL standard
> To: Klaus Ita <postgres(at)stro(dot)at>
> Cc: pgsql-bugs(at)postgresql(dot)org
> X-Virus-Scanned: by Amavis (ClamAV) at stro.at
>
> Klaus Ita wrote:
> >
> >i have the following data:
> >
> >table L:
> >LNR ORT LCODE MENGE
> >L1 Graz A 1000
> >L2 Wien C 500
> >L3 Wien C 1500
> >L4 Linz B 1000
> >L5 Graz B 300
> >
> >
> >table P:
> >PNR PNAME ORT PREIS
> >P1 Alpha Wien 50.00
> >P2 Delta Linz 95.00
> >P3 Sigma Linz 75.00
> >P4 Omega Wien 40.00
> >
> >
> >now the problem:
> >
> >select l.ort;
> >gives:
> >
> >ORT
> >Graz
> >Wien
> >Wien
> >Linz
> >Graz
> >
> >
> >select l.ort from p;
> >gives:
> >
> >ORT
> >Graz
> >Wien
> >Wien
> >Linz
> >Graz
> >Graz
> >Wien
> etc
>
> Does it still do it if you disable "add_missing_from" in postgresql.conf?
> --
> Richard Huxton
> Archonet Ltd