Horton

Re: Boolean output format

Martijn van Oosterhout <kleptog@svana.org>

View thread View on postgr.es
From: Martijn van Oosterhout <kleptog@svana.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Garo Hussenjian <garo@xapnet.com>, Jeff Davis <list-pgsql-general@empires.org>, Postgresql General <pgsql-general@postgresql.org>
Date: 2002-10-07T12:41:31Z
Lists: pgsql-general 
On Sat, Oct 05, 2002 at 08:54:11PM -0400, Tom Lane wrote:
> Garo Hussenjian <garo@xapnet.com> writes:
> > Also, is it really the case that the adapters (JDBC, DBI, others) actually
> > process database output?
> 
> Well, maybe they don't.  If they don't then the compatibility issue
> largely goes away, I think.

They do. DBI at least converts t/f into 1/0 which confused the hell out of
me the first time I saw it. I was using eq "t" and eq "f" in my if
statements, and the response was matching neither.

It also returns undef for fields with NULL where Pg returned "".

-- 
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.