Postgres Pro
Downloads
Home   >   mailing lists

BUG #1796: UNION ALL of NULL <=> type = text so mimack pb - Mailing list pgsql-bugs

From Mansion
Subject BUG #1796: UNION ALL of NULL <=> type = text so mimack pb
Date
Msg-id 20050728130530.0EF82F0B01@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1796: UNION ALL of NULL <=> type = text so mimack pb  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: pod@herald.ox.ac.uk (pod)
Date:
Subject: Re: krb5 authentication and multihomed server hosts
Next
From: "kam k"
Date:
Subject: BUG #1795: mirroring