Re: cast bool/int

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: Zdravko Balorda <zdravko(dot)balorda(at)siix(dot)com>
Subject: Re: cast bool/int
Date: 2009-03-23 08:15:11
Message-ID: 200903231015.11528.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Στις Monday 23 March 2009 09:59:12 ο/η Zdravko Balorda έγραψε:
>
> Hi,
> I need a casting operator from boolean to integer,
> tu put in ALTER TABLE statment after USING.
>

How about
CASE WHEN 't' THEN 1 ELSE 0 END

> Any ideas? Thanks.
>
> Zdravko
>
>

--
Achilleas Mantzios

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleas Mantzios 2009-03-23 08:18:31 Re: cast bool/int
Previous Message Ivan Sergio Borgonovo 2009-03-23 08:09:42 Re: bash & postgres