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

(excuse me, if it's a little off topic)

hello all,

I am just trying to (finally) upgrade from Pg.pm to
DBI (DBD::Pg) ...

I encounter the following problem:

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'.

This is a problem for me, because of hundred thousands
lines of code containing many many comparisons in perl
like: if ($member eq "t") { foo; } -- which I really
don't fance to change one by one...

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' ?

thanks,

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
--------------------------------------------------------

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

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

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(at)city-map(dot)de> wrote:
> thanks, this works fine for me ;-)
>
> happy new year,
>
>
> --
>
> Mit freundlichem Gru
>
> Henrik Steffen
> Geschftsfhrer
>
> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)

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

On Tue, 31 Dec 2002 08:34:54 -0800 (PST), Michael Teter wrote:
> With each successive release of DBD::Pg, you'll have to go modify the
> module again...

Well, I just sent in a patch which makes this behaviour switchable with
a database handle attribute, so maybe it'll be in the next version of
the driver.

--
Peter Haworth pmh(at)edison(dot)ioppublishing(dot)com
'As Annie Oakley almost said, "Anything you can do, I can do meta."'
-- Larry Wall

Very nice of you :)

I thought it, but didn't suggest it since I'm not
qualified to make such a change.

MT

--- Peter Haworth <pmh(at)edison(dot)ioppublishing(dot)com>
wrote:
> On Tue, 31 Dec 2002 08:34:54 -0800 (PST), Michael
> Teter wrote:
> > With each successive release of DBD::Pg, you'll
> have to go modify the
> > module again...
>
> Well, I just sent in a patch which makes this
> behaviour switchable with
> a database handle attribute, so maybe it'll be in
> the next version of
> the driver.
>
> --
> Peter Haworth pmh(at)edison(dot)ioppublishing(dot)com
> 'As Annie Oakley almost said, "Anything you can do,
> I can do meta."'
> -- Larry Wall
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)

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

how to connect html page to psql ?

=====
Take careMohd.Ghalib Akhtar(office)91-11-6152172,Ext-217
Fax : 91-11-6146217, 6149446
---------------------------------

---------------------------------

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

Why do you want to do that?

Can you explain more on what you are trying to do?

At 04:08 AM 1/1/03 -0800, Mohd Ghalib Akhtar wrote:

>how to connect html page to psql ?
>
>=====
>Take careMohd.Ghalib Akhtar(office)91-11-6152172,Ext-217
>Fax : 91-11-6146217, 6149446

Try SSI (Server Side Include)...

I have feeling you mean something else....something like how do you
write a web (or HTML)
based application with PG backend.

Mohd Ghalib Akhtar wrote:

>how to connect html page to psql ?
>
>=====
>Take careMohd.Ghalib Akhtar(office)91-11-6152172,Ext-217
>Fax : 91-11-6146217, 6149446
>---------------------------------
>
>---------------------------------
>
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>