From: | Klaus Ita <postgres(at)stro(dot)at> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: select clause not according to SQL standard |
Date: | 2005-02-25 14:51:08 |
Message-ID: | 20050225145108.GH17644@ai.wu-wien.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-02-25 15:41:26 | Re: select clause not according to SQL standard |
Previous Message | Richard Huxton | 2005-02-25 14:37:12 | Re: select clause not according to SQL standard |