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  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Lee Thompson
Дата:
Сообщение: Re: BUG #2170: --rpath option is skipping shared libs
Следующее
От: "Roberto"
Дата:
Сообщение: BUG #2175: 22021: invalid byte sequence for encoding \"UNICODE\":