Re: BUG #1796: UNION ALL of NULL <=> type = text so mimack pb

On Thu, Jul 28, 2005 at 02:05:30PM +0100, Mansion wrote:
>
> on the table rien with the column "ordre" (int type)
> When i write :
> INSERT INTO rien (ordre) SELECT NULL UNION ALL SELECT NULL
> i have the error :
> column "ordre" is of type integer but expression is of type text

The complete error message gives a hint about how to solve this problem:

CREATE TABLE rien (ordre integer);
INSERT INTO rien (ordre) SELECT NULL UNION ALL SELECT NULL;
ERROR: column "ordre" is of type integer but expression is of type text
HINT: You will need to rewrite or cast the expression.

For more information see "UNION, CASE, and ARRAY Type Resolution"
in the documentation:

http://www.postgresql.org/docs/8.0/static/typeconv-union-case.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/