Re: [HACKERS] Re: Recent updates [to union] - Mailing list pgsql-hackers

From Andreas Zeugswetter
Subject Re: [HACKERS] Re: Recent updates [to union]
Date
Msg-id 01BDAF48.489C7080@zeugswettera.user.lan.at
Whole thread Raw
List pgsql-hackers
>> The problem appears to be in the sorting of nulls, which is used by
>> UNION ALL:
>>         test=> select null order by 1;
>>         ERROR:  type id lookup of 0 failed
>
>Hmm. And I've got trouble with the following when I assigned the type
>"UNKNOWNOID" to the null fields:

I think this is ok. Since the first select has to define the datatype, I think a forced
typecasting (like NULL::varchar) is perfectly OK in the above case.

Andreas



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: AW: [HACKERS] Sequence objects have no global currval operator?
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] atttypmod now 32 bits, interface change