Re: boolean 't' 'f' vs. '1' '0' - perl question - Mailing list pgsql-general

From Michael Teter
Subject Re: boolean 't' 'f' vs. '1' '0' - perl question
Date
Msg-id 20021231163454.4313.qmail@web14801.mail.yahoo.com
Whole thread Raw
In response to Re: boolean 't' 'f' vs. '1' '0' - perl question  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
With each successive release of DBD::Pg, you'll have
to go modify the module again...

Wouldn't it make more sense to modify your code to use
1/0 instead?

MT

--- Henrik Steffen <steffen@city-map.de> wrote:
> 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@topconcepts.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@edison.ioppublishing.com>
> To: "Henrik Steffen" <steffen@city-map.de>;
> <pgsql-general@postgresql.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@edison.ioppublishing.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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

pgsql-general by date:

Previous
From: Martin_Hurst@dom.com
Date:
Subject: ODBC - adding missing FROM clause entry
Next
From: Tom Lane
Date:
Subject: Re: Is postgresql download still working?