Re: mssql migration and boolean to integer problems - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: mssql migration and boolean to integer problems
Date
Msg-id 350222.58437.qm@web31806.mail.mud.yahoo.com
Whole thread Raw
In response to Re: mssql migration and boolean to integer problems  (robert <robertlazarski@gmail.com>)
List pgsql-general
--- On Thu, 12/13/07, robert <robertlazarski@gmail.com> wrote:

> > Hi all, I've spent the last few days hacking a
> mssql INSERT script to
> > work with 8.1.9 - I could build the latest postgres
> source if need be.

a standard cast() wouldn't work for you?

proj02u20411=> select cast( 1 as boolean),
proj02u20411=> cast( 0 as boolean),
proj02u20411=> cast( -1 as boolean ),
proj02u20411=> cast( 2 as boolean);

 bool | bool | bool | bool
------+------+------+------
 t    | f    | t    | t

Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: user name and password woes
Next
From: "Heiner Vega"
Date:
Subject: postgres writer process growing up too much