JDBC: what exactly does nullsAreSortedHigh() return?

Поиск
Список
Период
Сортировка
От vikasrana@techie.com (Vikas Rana)
Тема JDBC: what exactly does nullsAreSortedHigh() return?
Дата
Msg-id f8961319.0406022225.3b5cfde0@posting.google.com
обсуждение исходный текст
Ответы Re: JDBC: what exactly does nullsAreSortedHigh() return?  (Derek Chen-Becker <dbecker@cpicorp.com>)
Список pgsql-general
Hi all,

  I am a bit confused about the method
java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this
return? If this returns true, are nulls considered as the highest
value? Or does this mean that nulls comes first when sorted in
ascending order (opposite in meaning to the first).

Consider this.

- Oracle returns false. Nulls are last when sorted in ascending order.

- MSSQL2K returns true. Nulls are first when sorted in ascending
order.

- Postgres returns true. Nulls are last when sorted in ascending
order.

Now, behavior of Oracle and Postgres is same in terms of sort order,
but they return different values.

Who is right?

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: CREATE DATABASE on the heap with PostgreSQL?
Следующее
От: Derek Chen-Becker
Дата:
Сообщение: Re: JDBC: what exactly does nullsAreSortedHigh() return?