| From: | "Vic" <vic(at)stream(dot)net(dot)ua> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2172: Problem with query in order by |
| Date: | 2006-01-16 15:25:51 |
| Message-ID: | 20060116152551.A0995F0ACA@svr2.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2172
Logged by: Vic
Email address: vic(at)stream(dot)net(dot)ua
PostgreSQL version: 8.0.6
Operating system: FreeBSD 5.4/6.0
Description: Problem with query in order by
Details:
when I send query
"select *
from nets a,systbl
where a.type = systbl.tbl_
and a.cid_ = 155
and systbl.tblid = 'nettype'
order by a.endd, net; " - all working fine,
but
when I write in "order by" next: "order by nets.endd,net"
(I'm chane a. to nets. )
postgres returrn me linked "a" table with "systbl" by where phrase, and also
full link with nets table again
Sorry for my bad english :(,
I can send to email full describe tables and result of to select
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcin | 2006-01-16 18:09:09 | Huge number of disk writes after migration to 8.1 |
| Previous Message | Rafał | 2006-01-15 20:12:44 | [PostgreSQL 8.1.2] GRANT ALL ... role1 and relation does not exist |