My issue is with the output of the ODBC driver.
The data type of the output of the ODBC driver changes if you do not have records.
You answers are the data type out of postgres directly without the ODBC driver.
You need the run the sql through the ODBC driver (which you said you are not).
Can someone else try the test sql through the ODBC driver?
SELECT initcap(vcharfield) vv FROM table (returns varchar)
vs
SELECT initcap(vcharfield) vv FROM table WHERE 1=0
Returns text
Barry Bell
Senior Developer/Analyst
Logistics
Harte Hanks
1525 NW 3rd ST
Deerfield Beach FL, 33442
954-429-3771 Ext 267 office
954-281-1464 fax
hartehanks.com / linkedin / twitter / facebook
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Wednesday, May 14, 2014 9:50 AM
To: Barry Bell; Hiroshi Saito; Michael Paquier; Hiroshi Inoue
Cc: Heikki Linnakangas; Anna Gershnik; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] psqlODBC text length with no records
On 05/14/2014 06:31 AM, Barry Bell wrote:
> I am referring the output of the odbc driver from SQL statement:
> SELECT initcap('ABCDEF')::varchar vv FROM dual WHERE 1=0
>
> You link only show the date type in postgres and I am asking about the driver output.
This is what you asked:
"You said the initcap function return "text", Is this a "short" text like a varchar Or a long text like a clob,memo
etc?"
and I answered that question.
> Are you using this statement with the ODBC driver?
No, as I said previously I do not have an ODBC set up available at the moment.
> (Output from the ODBC driver may be different format then for pg admin etc).
>
> SELECT initcap('ABCDEF')::varchar vv FROM dual WHERE 1=0 I am
> expending a "character varying" or "varchar" output from the sql
> statement But the I getting the postgres "text"
> If the SQL is changed to return records, SELECT
> initcap('ABCDEF')::varchar vv FROM dual The output is varchar
>
> So
> SELECT initcap('ABCDEF')::varchar vv FROM dual Works, returns varchar
> So the issues is with:
> SELECT initcap('ABCDEF')::varchar vv FROM dual WHERE 1=0 Returning
> "text", sqllongvar a different type then above, Does not change with
> any unknownsize or datetype setting in ODBC driver.
As I recall this is eventually ending up in a VFP application. So where are you actually seeing the different behavior,
inthe app or somewhere before the app?
>
> Barry Bell
--
Adrian Klaver
adrian.klaver@aklaver.com