Re: no self-joins in views? - Mailing list pgsql-general

From Richard Huxton
Subject Re: no self-joins in views?
Date
Msg-id 420B919C.9060907@archonet.com
Whole thread Raw
In response to no self-joins in views?  (Christoph Pingel <ch.pingel@web.de>)
Responses Re: no self-joins in views?  (Christoph Pingel <ch.pingel@web.de>)
List 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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Python Interface
Next
From: Martijn van Oosterhout
Date:
Subject: Re: no self-joins in views?