Re: boolean to int

From: "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in>
To: Mage <mage(at)mage(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: boolean to int
Date: 2004-03-15 20:06:26
Message-ID: 40560CC2.1030900@sancharnet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jabber(dot)org
ICQ : 264360076
Yahoo IM: mailforvishal(at)yahoo(dot)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---------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Cohen 2004-03-15 20:11:19 type definitions
Previous Message Tom Lane 2004-03-15 19:37:27 Re: Character escape in "CREATE FUNCTION ..."