Hi, I try to do what seems to be totally simple, but it fails. If I query a view that contains renamed columns without any qualifier like
SELECT * FROM myview it displays everything. If however I do SELECT reanmedviewcolumn FROM myview It tells me column does not exist which in fact does. I can query any non-renamed columns. But the renamed ones I can neither call by their original name, not int he SELECT part nor in the WHERE clause. I can neither leave the view with just the original names as it's a selfjoin. What do I need to do? Thanks Alex -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
