[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Cannot query views with WHERE clause on renamed columns
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2014-06-30 22:59:56
Message-ID: 24334.1404169196 () sss ! pgh ! pa ! us
[Download RAW message or body]

Alexander Reichstadt <lxr@mac.com> writes:
> 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.

What do you mean by a "renamed column"?  A concrete example would help
here.

			regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[prev in list] [next in list] [prev in thread] [next in thread]