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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match