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

From: "Mansion" <michael(dot)mansion(at)u-picardie(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1796: UNION ALL of NULL <=> type = text so mimack pb
Date: 2005-07-28 13:05:30
Message-ID: 20050728130530.0EF82F0B01@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1796
Logged by: Mansion
Email address: michael(dot)mansion(at)u-picardie(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Dabney 2005-07-28 13:27:40 Re: Insert statement changes timestamp value from MS Access
Previous Message pod 2005-07-28 12:28:52 Re: krb5 authentication and multihomed server hosts