Re: WARNING: column "footype" has type "unknown"

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)