On Wednesday October 27 2004 5:24, Tom Lane wrote: > An example of what you won't be able to do: > > regression=# select distinct * from fooview; > ERROR: failed to find conversion function from "unknown" to text
Is that 8.0 you're working against there? Here's my 7.4.6 installation: $ psql -c "create view fooview as select 'bar' as footype" WARNING: column "footype" has type "unknown" DETAIL: Proceeding with relation creation anyway. CREATE VIEW $ psql -c "select * from fooview" footype --------- bar (1 row) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])