Re: boolean 't' 'f' vs. '1' '0' - perl question

thanks, this works fine for me ;-)

happy new year,

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Peter Haworth" <pmh(at)edison(dot)ioppublishing(dot)com>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>; <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, December 31, 2002 4:11 PM
Subject: Re: [GENERAL] boolean 't' 'f' vs. '1' '0' - perl question

> On Tue, 31 Dec 2002 15:18:08 +0100, Henrik Steffen wrote:
> > I am just trying to (finally) upgrade from Pg.pm to
> > DBI (DBD::Pg) ...
> >
> > Until today, Pg.pm delivered a 't' or a 'f' for
> > true or false boolean values.
> >
> > Since the upgrade, DBI delivers a '1' or a '0'.
> >
> > Question: Does anyone know if there's possibly a
> > parameter to set to tell DBI to deliver 't' and 'f'
> > instead of '1' and '0' ?
>
> Not in the current version. It looks like it should be easy enough to
hack,
> though. Just remove lines 1360-1362 of dbdimp.c:
>
> if (16 == type) {
> *val = (*val == 'f') ? '0' : '1'; /* bool: translate
postgres into perl */
> }
>
> This will probably mean that tests will fail, but looks harmless enough
> otherwise.
>
>
> --
> Peter Haworth pmh(at)edison(dot)ioppublishing(dot)com
> "I don't have to impress you. And as you're an emacs weenie who
> doesn't even speak Martian Swahili, I would never expect to."
> -- Tom Christiansen