Re: no self-joins in views?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Christoph Pingel <ch(dot)pingel(at)web(dot)de>
Cc: postgresql-general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: no self-joins in views?
Date: 2005-02-10 16:53:48
Message-ID: 420B919C.9060907@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Christoph Pingel wrote:
> Hello,
>
> is there any restriction re the use of self joins in views? I have a
> moderately complicated query where I scan the same table twice using
> aliases, and I would like to put that into a view to keep my python code
> clean. However, I get an error 'column xy duplicated'. Is this so by
> design?

Could you give an actual example?

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-02-10 16:54:20 Re: no self-joins in views?
Previous Message Joshua D. Drake 2005-02-10 16:19:19 Re: Python Interface