On Wednesday October 27 2004 5:34, Ed L. wrote:
> 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 work
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
"Ed L." <[EMAIL PROTECTED]> writes:
> On 7.4.6, is there any problem with defining one column of a view to be a
> string literal? For example ...
> $ psql -c "create view fooview as select 'bar' as footype"
> WARNING: column "footype" has type "unknown"
> DETAIL: Proceeding with relation creat
On 7.4.6, is there any problem with defining one column of a view to be a
string literal? For example ...
$ psql -c "create view fooview as select 'bar' as footype"
WARNING: column "footype" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
CREATE VIEW
Or is this warning j
