--- On Thu, 12/13/07, robert <robertlazarski@xxxxxxxxx> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
