BUG #2172: Problem with query in order by

Поиск
Список
Период
Сортировка
От Vic
Тема BUG #2172: Problem with query in order by
Дата
Msg-id 20060116152551.A0995F0ACA@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2172: Problem with query in order by
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2172
Logged by:          Vic
Email address:      vic@stream.net.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

В списке pgsql-bugs по дате отправления: