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

Re: select clause not according to SQL standard

From: Richard Huxton <dev(at)archonet(dot)com>
To: Klaus Ita <postgres(at)stro(dot)at>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: select clause not according to SQL standard
Date: 2005-02-25 14:37:12
Message-ID: 421F3818.5070301@archonet.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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: Klaus ItaDate: 2005-02-25 14:51:08
Subject: Re: select clause not according to SQL standard
Previous:From: postgresbugsDate: 2005-02-25 14:16:42
Subject: PGPASSWORD

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