Re: select clause not according to SQL standard

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