<small><font>Is this normal Postgres / psql behavior?<br /><br /> griffindb=# \d system.user;<br />
Table "system.user"<br /> Column | Type |
Modifiers<br/><br /> -----------+-----------------------+--------------------------------------------<br /> --------<br
/> username | character varying(20) | not null<br /> password | character varying(32) | not null<br /> firstname |
charactervarying(40) | not null default 'nema ime'::character vary<br /> ing<br /> lastname | character varying(40) |
notnull default 'nema prezime'::character<br /> varying<br /> Indexes:<br /> "SystemUser_PK" PRIMARY KEY, btree
(username)CLUSTER<br /><br /> normal query: <br /><br /> griffindb=# select * from system.user where username =
'root';<br/> username | password | firstname | lastname<br />
----------+----------------------------------+-----------+---------------<br/> root |
1e7db545fccbf4e03abc6b71d329ab4f| Super | administrator<br /> (1 row)<br /><br /> error query:<br /><br />
griffindb=#select * from system.user where user = 'root';<br /> username | password | firstname | lastname<br />
----------+----------+-----------+----------<br/> (0 rows)<br /><br /> column user does not exist should throw an
error!<br/><br /> PostgreSQL / psql version: 9.1.3 on Windows 7 64-bit<br /><br /> Should Postgres or psql report an
errorbecause column used in WHERE clause does not exist? </font><br /></small>