| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Garo Hussenjian <garo(at)xapnet(dot)com>, Jeff Davis <list-pgsql-general(at)empires(dot)org>, Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Boolean output format |
| Date: | 2002-10-07 12:41:31 |
| Message-ID: | 20021007124131.GC24034@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Oct 05, 2002 at 08:54:11PM -0400, Tom Lane wrote:
> Garo Hussenjian <garo(at)xapnet(dot)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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2002-10-07 12:44:17 | Re: deadlock using sequences? |
| Previous Message | Larry Rosenman | 2002-10-07 12:31:11 | [Fwd: FOUND VIRUS IN MAIL from <pgsql-general-owner+M31348@postgresql.org>] |