[EMAIL PROTECTED] (Tom Lane) wrote:
The cure is to cast the literal to some specific type when you
do the CREATE.
I figured that was the case, and pointed that cure back to the
developer.
What I was hoping to hear was some way of coercing the data into a
more usable type after the fact. The
We have encountered a pretty oddball situation involving an unknown type.
mydb=# select version();
version
Chris Browne [EMAIL PROTECTED] writes:
We have encountered a pretty oddball situation involving an unknown type.
The way you get this sort of thing is with
CREATE VIEW foo AS SELECT ... , 'literal', ...
The undecorated literal is initially of type UNKNOWN, and there's
nothing to cause it to