Re: [GENERAL] Typecasting datetype as date. How do I cope with NULLs? - Mailing list pgsql-general

From tolik@icomm.ru (Anatoly K. Lasareff)
Subject Re: [GENERAL] Typecasting datetype as date. How do I cope with NULLs?
Date
Msg-id x7sof5xwre.fsf@tolikus.hq.aaanet.ru
Whole thread Raw
In response to Re: [GENERAL] Typecasting datetype as date. How do I cope with NULLs?  ("Wim Ceulemans" <wim.ceulemans@nice.be>)
List pgsql-general
>>>>> "WC" == Wim Ceulemans <wim.ceulemans@nice.be> writes:


 WC> I find the above interesting and I've tried something similar that won't
 WC> work.
 WC> I have two tables defined as follows

 WC> create table test1 (id1 int,link1 int);
 WC> create table test2 (id2 int, field2 varchar(5));

 WC> where link1 is a foreign key of test1 that should be linked to id2 of test2

 WC> Now when I execute the following query:

 WC> select id1,field2,link1 from test1,test2 where test1.link1=test2.id2
 WC> union
 WC> select id1,NULL,link1 from test1;

 WC> I always get the following error:

 WC> Each UNION query must have identical target types.

 WC> Why this error, and what does it mean?

Pehaps this is a bug fixed in 6.4 version? I saw this message when
before upgrating to 6.4. You can modify query so:

select id1,field2,link1 from test1,test2 where test1.link1=test2.id2
 union
select id1, -1, link1 from test1;

where -1 is value non present in field2 domain.

--
Anatoly K. Lasareff              Email:       tolik@icomm.ru
Senior programmer

pgsql-general by date:

Previous
From: "Wim Ceulemans"
Date:
Subject: Re: [GENERAL] Typecasting datetype as date. How do I cope with NULLs?
Next
From: Stuart Rison
Date:
Subject: Re: [GENERAL] Typecasting datetype as date. How do I cope with NULLs?