no self-joins in views?

From: Christoph Pingel <ch(dot)pingel(at)web(dot)de>
To: postgresql-general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: no self-joins in views?
Date: 2005-02-10 16:13:51
Message-ID: a06100501be313778a604@[62.224.60.178]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

best,
Christoph

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-02-10 16:19:19 Re: Python Interface
Previous Message Michael Fuhr 2005-02-10 16:03:49 Re: Python Interface