Re: casting from integer to boolean

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, Seb <spluque(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: casting from integer to boolean
Date: 2008-03-27 12:40:33
Message-ID: 396486430803270540m6fad3e3br6b09ddcc2ad6e8fb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 27, 2008 at 12:40 AM, Martijn van Oosterhout <kleptog(at)svana(dot)org>
wrote:

> Don't think anyone mentioned it, but if you could get it to output
> quotes around the value, like:
>
> INSERT INTO my_table (var_bool) VALUES ('0');
>
> It will also work.
>

This is good to know. There is an option in the ODBC driver to treat
booleans as a char. Maybe this would be a good solution.

--
Regards,
Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-03-27 12:45:46 Re: Using tables in other PostGreSQL database
Previous Message Albe Laurenz 2008-03-27 12:28:20 Re: Performance of update