Re: mssql migration and boolean to integer problems

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org, robert <robertlazarski(at)gmail(dot)com>
Subject: Re: mssql migration and boolean to integer problems
Date: 2007-12-14 17:32:01
Message-ID: 350222.58437.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- On Thu, 12/13/07, robert <robertlazarski(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Heiner Vega 2007-12-14 17:43:24 postgres writer process growing up too much
Previous Message Richard Huxton 2007-12-14 17:31:23 Re: user name and password woes