any way for ORDER BY x to imply NULLS FIRST in 8.3?

Поиск
Список
Период
Сортировка
От rihad
Тема any way for ORDER BY x to imply NULLS FIRST in 8.3?
Дата
Msg-id 473019F5.1010702@mail.ru
обсуждение исходный текст
Ответы Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?  (Reece Hart <reece@harts.net>)
Список pgsql-general
Is there any way to "hardcode" the NULL handling in an index (as  per
http://www.postgresql.org/docs/8.3/static/indexes-ordering.html) so that
SELECT * FROM t ORDER BY foo automatically implies NULLS FIRST (and,
similarly so that SELECT * FROM t ORDER BY foo DESC automatically
implies NULLS LAST)? Thing is, I'm using PHP Symfony/Propel to generate
their SQL and have no easy way to influence how they do so.

Thanks.

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: for libpq which include defines the type oids
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: php and postgres - too many queries too fast?