"Brian Cox" <[EMAIL PROTECTED]> writes:
> any_db=> create view view1 as select null as col1 from any_table;
> CREATE VIEW
You seem to have ignored the warning telling you this probably wasn't
a good idea:
regression=# create view view1 as select null as col1;
WARNING: column "col1" has type "unk
The following bug has been logged online:
Bug reference: 1904
Logged by: Brian Cox
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux (Fedora Core 2)
Description:using distinct with null col causes error
Details:
any_db=> create view
