Re: [PATCHES] PQescapeBytea documentation patch

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: Joe Conway <joseph(dot)conway(at)home(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [PATCHES] PQescapeBytea documentation patch
Date: 2001-11-21 12:25:55
Message-ID: 20011121122555.B21102@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-interfaces pgsql-patches

On Tue, Nov 20, 2001 at 12:21:00PM -0800, Joe Conway wrote:
> Here's a patch adding documentation for the PQescapeBytea function to
> libpq.sgml
...
+ <function>PQescapeBytea</function>
+ Escapes a binary string (bytea type) for use within an SQL query.
+ <synopsis>
+ unsigned char *PQescapeBytea(unsigned char *from,
+ size_t from_length,
+ size_t *to_length);

This makes me wonder: should libpq contain a function to do the opposite
too? eg.

string=GetValue(from a bytea type column)
PQunescapeBytea(string, some buffer, buffer's size)

- or is there already another way of doing it?

It seems to me that anyone using bytea with libpq will end up having
to reinvent this wheel. (Something worthy of being knocked up in my
Copious Free Time (tm))

Cheers,

Patrick

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Ezra Epstein 2001-11-21 15:32:04 Oracle -> PostgreSQL ==> RAW -> ???
Previous Message Bruce Momjian 2001-11-21 03:17:47 Re: bytea datatype documentation patch

Browse pgsql-interfaces by date

  From Date Subject
Next Message Chitta Barik 2001-11-21 15:50:37 closing connection while cancelling
Previous Message Bell John 2001-11-21 03:05:27 Re: What front end are people using?

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-11-21 15:06:09 Re: Rejection of the smallest int8
Previous Message sugita 2001-11-21 05:50:28 Rejection of the smallest int8