[ psqlodbc-Bugs-1000759 ] SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000759 ] SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH
Date
Msg-id 20061020020407.18DE6216D56@pgfoundry.org
Whole thread Raw
List pgsql-odbc
Bugs item #1000759, was opened at 2006-10-19 05: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: Hiroshi Inoue (hinoue)
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
toactual 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.


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

>Comment By: Hiroshi Inoue (hinoue)
Date: 2006-10-20 02:04

Message:
SQL_NC_END had been right until 7.2 came.
OK please try the attached dll.

regards,
Hiroshi Inoue

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

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

pgsql-odbc by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Improve ODBC Throughput ?
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000745 ] SQLStatistics does not return indices based on expression