| 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: | Whole Thread | Raw Message | 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 |