Re: UNION syntax different for 7.1.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UNION syntax different for 7.1.2
Date: 2001-07-19 18:11:36
Message-ID: 24667.995566296@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> writes:
> from 7.0.2 to 7.0.3, the following script works fine, but in 7.1.2 I
> must remove the rr. from ORDER BY clause.

Yup. That's an intentional change. The ORDER BY applies to the output
columns of the UNION, not to whatever tables might have been referenced
in the arms of the UNION.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-19 18:26:00 Re: many tables in db
Previous Message Ed Loehr 2001-07-19 17:29:42 Re: UNION syntax different for 7.1.2