Re: boolean to int - Mailing list pgsql-general

From V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Subject Re: boolean to int
Date
Msg-id 40560CC2.1030900@sancharnet.in
Whole thread Raw
In response to boolean to int  (Mage <mage@mage.hu>)
List pgsql-general
Dear Mage ,

>
> I'm wondering why pgsql doesn't support boolean typecasts like select
> true::int;
> Many client applications including php assign 1 to true and 0 to false

This was a issue PHP  < 4.2 +  < PostgreSQL 7.3.x  and supports it till
now for backward compatibility

--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap@jabber.org
ICQ :      264360076
Yahoo  IM: mailforvishal@yahoo.com
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
pgsql=# select marital_status from vishals_life;

marital_status
------------------
Single not looking

1 Row(s) affected

                    ___
                   //\\\
                  ( 0_0 )
----------------o0o-----o0o---------------------


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Character escape in "CREATE FUNCTION ..."
Next
From: Tom Lane
Date:
Subject: Re: Character escape in "CREATE FUNCTION ..."