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