> postgres=> select null union all select null;
> ?column?
> --------
> 
> 
> (2 rows)
> 
> An additional problem is that the UNION parsing is done recursively, so
> the routine which does the type matching does not see a list of all the
> clauses all at once.
> 
> Any ideas?

I knew there was a reason I did not support NULL in union.  :-)

Just kidding.  I never thought of testing it, and a good thing too.  :-)

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

• Re: Recent updates at 1998-07-14 13:38:53 from Thomas G. Lockhart

Responses

• Re: Recent updates at 1998-07-14 15:12:20 from Thomas G. Lockhart

pgsql-hackers by date

Next:	From: Tom Lane	Date: 1998-07-14 14:10:05
	Subject: Re: [HACKERS] HPUX Port
Previous:	From: Bruce Momjian	Date: 1998-07-14 13:42:47
	Subject: Re: [HACKERS] atttypmod now 32 bits, interface change