psqlodbc - dayofweek and week functions are not supported but actually are

From: xsgao(at)aim(dot)com
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlodbc - dayofweek and week functions are not supported but actually are
Date: 2019-03-27 18:43:15
Message-ID: 253242280.12504498.1553712195648@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

When calling SQLGetInfo(SQL_TIMEDATE_FUNCTIONS), psqlodbc tells that WEEKOFDAY and WEEK are not supported. But in convert.c, it converts these two functions to extrat(dow/week from $1). So if you just send dayofweek() in a query, PostgreSQL will return correct values.
So in this method of info.c:
RETCODE  SQL_API
PGAPI_GetInfo(HDBC hdbc,
     SQLUSMALLINT fInfoType,
     PTR rgbInfoValue,
     SQLSMALLINT cbInfoValueMax,
     SQLSMALLINT * pcbInfoValue)
You need to append two more bits:
  case SQL_TIMEDATE_FUNCTIONS: /* ODBC 1.0 */
   len = 4;
   value = (SQL_FN_TD_NOW | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_WEEK );
   break;

I am using  10.03.0000.
thanks,Song X. Gao

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2019-03-29 00:15:47 Re: psqlodbc - dayofweek and week functions are not supported but actually are
Previous Message Inoue, Hiroshi 2019-03-27 01:01:08 Re: setLastTid() and currtid()