Re: [PATCHES] libpq type system 0.9a - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: [PATCHES] libpq type system 0.9a
Date
Msg-id 1207704483.4478.97.camel@dogma.ljc.laika.com
Whole thread Raw
In response to Re: [PATCHES] libpq type system 0.9a  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [PATCHES] libpq type system 0.9a  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-hackers
On Tue, 2008-04-08 at 12:59 -0400, Bruce Momjian wrote:
> If you need something exposed by
> libpq that is not there already, please let us know.

The things that I found missing in libpq so far are:
* The ability to choose some result columns to be binary-formatted and
others to be text-formatted. I haven't thought of a reasonable API for
this yet, particularly since we already have so many ways of executing a
statement.
* an "escapeIdent" function.
* PQescapeBytea escapes for both inclusion in a SQL statement and also
the escaping for the input function for bytea. This means that, if you
are passing a binary value as a text-format parameter, using
PQescapeBytea is incorrect, and you need to write your own octal escape
routine. This is obviously a minor complaint, and may not even be worth
polluting the namespace. I only mention it because it seems like an easy
mistake to make.

I don't have a proposal ready for any of these yet, but this is what
I've found to be awkward or limiting during my work on ruby-pg. If I
have a more complete proposal I'll start a new thread.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: [PATCHES] libpq type system 0.9a
Next
From: "Merlin Moncure"
Date:
Subject: Re: [PATCHES] libpq type system 0.9a