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

The following bug has been logged online:

Bug reference:      1796
Logged by:          Mansion
Email address:      michael.mansion@u-picardie.fr
PostgreSQL version: 8.0.3
Operating system:   windows XP
Description:        UNION ALL of NULL <=> type = text so mimack pb
Details:

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

Thanks in advance michael From France

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/