Re: no self-joins in views?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: no self-joins in views?
Дата
Msg-id 420B919C.9060907@archonet.com
обсуждение исходный текст
Ответ на no self-joins in views?  (Christoph Pingel <ch.pingel@web.de>)
Ответы Re: no self-joins in views?  (Christoph Pingel <ch.pingel@web.de>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Python Interface
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: no self-joins in views?