On Mon, Sep 14, 2009 at 10:40 PM, the6campbells <the6campbe...@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5056
> Logged by: the6campbells
> Email address: the6campbe...@gmail.com
> PostgreSQL version: 8.4.1
> Operating system: windows
> Description: SQLDescribeColW for function returning a result set
> incorrectly setting sql_nullable
> Details:
>
> create table TSET1 (RNUM integer not null, C1 integer, C2 char(3));
>
> create function PRES ( )
> returns setof TSET1 as
> '
> select RNUM, C1, C2 from TSET1;
> ' LANGUAGE 'sql'
> ;
>
> in ODBC test sqlPrepare { call pres } then describe the columns. first
> column should be SQL_NO_NULLS not NULLABLE.
>
> Describe Column All:
> icol, szColName,
> *pcbColName, *pfSqlType, *pcbColDef, *pibScale,
> *pfNullable
>
> 1, rnum, 4, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>
> 2, c1, 2, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>
> 3, c2, 2, SQL_WCHAR=-8, 3, 0, SQL_NULLABLE=1
I think you may want to try here, for both this and your previous bug report.
pgsql-o...@postgresql.org
http://archives.postgresql.org/pgsql-odbc/
...Robert
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
