[ psqlodbc-Bugs-1000759 ] SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000759 ] SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH
Date: 2006-10-19 05:53:25
Message-ID: 20061019055325.31ED0216D8D@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Bugs item #1000759, was opened at 2006-10-19 09:53
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000759&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Dmitriy Ivanov (divanov)
Assigned to: Nobody (None)
Summary: SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH

Initial Comment:
With the ANSI dirver 08.02.0103, I get SQLGetInfo(SQL_NULL_COLLATION) => 4, i.e. SQL_NC_END. This obviously contradicts to actual results and PG documentation Part VI. Reference > SQL Commands > SELECT:

The null value sorts higher than any other value. In other words,
with ascending sort order, null values sort at the end, and with
descending sort order, null values sort at the beginning.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000759&group_id=1000125

Browse pgsql-odbc by date

  From Date Subject
Next Message Mohammad Arif 2006-10-19 08:10:46 Db connection problem
Previous Message Mark Morgan Lloyd 2006-10-18 08:18:49 Re: Installation on NT4 revisited