Skip site navigation (1) Skip section navigation (2)

Re: select clause not according to SQL standard

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 (view raw or flat)
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

In response to

Responses

pgsql-bugs by date

Next:From: Richard HuxtonDate: 2005-02-25 15:41:26
Subject: Re: select clause not according to SQL standard
Previous:From: Richard HuxtonDate: 2005-02-25 14:37:12
Subject: Re: select clause not according to SQL standard

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group