Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?

From: jose soares <jose(at)sferacarta(dot)com>
To: Jelle Ruttenberg <ruttenberg(at)neroc(dot)nl>
Cc: postgresql-interfaces <pgsql-interfaces(at)postgresql(dot)org>, postgresql-general <pgsql-general(at)postgresql(dot)org>, postgresql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?
Date: 1999-09-30 12:47:47
Message-ID: 37F35BF3.862BC069@sferacarta.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-generalpgsql-interfaces
I had the same problem using m$access as client because m$access treats the
boolean value like an integer
0=false and -1=true while PostgreSQL treats the same value like a string (
'true','t','1','y','yes','false','f','0','n','no').
I created the following function and operator and now it works.

create function MsAccessBool(bool,int4)  returns bool
  as '' language 'internal';

create operator = (
        leftarg=bool,
        rightarg=int4,
        procedure=MsAccessBool,
        commutator='=',
        negator='<>',
        restrict=eqsel,
        join=eqjoinsel
        );

José

PS: remember to uncheck the field: "Bools as char" in the ODBC manager.


Jelle Ruttenberg ha scritto:

> Hello all,
>
> I'm trying to connect from a ODBC-client to PostgreSQL on a Linux-server.
> All is going well, except that the ODBC-client seems not to recognize the
> PostgreSQL boolean-datatype.
>
> Is this really caused by PostgreSQL? If yes: is there a workaround, like
> altering the datatypename in the proper places (pg_type?)? If no: then it
> is another problem and can somebody give a hint?
>
> Thanks,
> Jelle.
>
> I tested and encountered it in the following testsituations:
>
> Situation 1:
> Client: Mac via OpenLink ODBC-Client
> Server: Linux RH 6.0 via OpenLink Requestbroker
> Result: it looks like PostgreSQL-boolean is converted to SQL_C_CHAR
>
> Situation 2:
> Client: NT with psqlODBC
> Server: same Linux
> Result: in MS-Query:
> -  viewing the table-definitions, it comes with the message that it
> doesn't recognize datatype 'bool'
> -  selecting values it looks like PostgreSQL-boolean is converted to a
> numeric
>
> PostgreSQL: 6.5.1
>
> --------------------------------------------------------------
>                    NEROC Publishing Solutions
>
>                       Jelle Ruttenberg
>
> De Run 1131, 5503 LB Veldhoven    Phone  : +31-(0)40-2586641
> P.O.Box 133, 5500 AC Veldhoven    Fax    : +31-(0)40-2541893
> The Netherlands                   E-mail : ruttenberg(at)neroc(dot)nl
> --------------------------------------------------------------
>
> ************


In response to

Responses

pgsql-bugs by date

Next:From: Moray McConnachieDate: 1999-09-30 15:24:58
Subject: Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?
Previous:From: Jelle RuttenbergDate: 1999-09-30 10:39:13
Subject: ODBC-client->Linux-server: datatype boolean not recognized?

pgsql-interfaces by date

Next:From: Jens GlaserDate: 1999-09-30 14:44:38
Subject: Re: [INTERFACES] DatabaseMetaData.getDatabaseProductVersion()
Previous:From: Ansley, MichaelDate: 1999-09-30 11:45:04
Subject: SSL and ODBC

pgsql-general by date

Next:From: Moray McConnachieDate: 1999-09-30 15:24:58
Subject: Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?
Previous:From: Jelle RuttenbergDate: 1999-09-30 10:39:13
Subject: ODBC-client->Linux-server: datatype boolean not recognized?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group