From: | Herbert Liechti <herbie(at)thinx(dot)ch> |
---|---|
To: | <terry(at)greatgulfhomes(dot)com> |
Cc: | "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: query problem in 7.2.1: serious planner issue |
Date: | 2002-07-04 18:05:03 |
Message-ID: | Pine.LNX.4.33.0207042004430.15109-100000@standbyme.thinx.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 4 Jul 2002 terry(at)greatgulfhomes(dot)com wrote:
> I cannot sort on a field that I join across tables. Here are the examples:
>
> If I do this:
> SELECT offers.lot_id, lots.project_id
> FROM offers, lots
> WHERE offers.lot_id = lots.lot_id
> AND ...
> UNION
> SELECT offers.lot_id, lots_deleted.project_id
> FROM offers, lots_deleted
> WHERE offers.lot_id = lots_deleted.lot_id
> AND ...
> ORDER BY lot_id
ORDER BY 1
Regards Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti http://www.thinx.ch
The content management company. Visit http://www.contentx.ch
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2002-07-04 18:06:31 | |
Previous Message | Lynn David Newton | 2002-07-04 17:57:32 | explicit cast error |