From: | "Joe Conway" <joseph(dot)conway(at)home(dot)com> |
---|---|
To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Karel Zak" <zakkr(at)zf(dot)jcu(dot)cz>, "Joerg Hessdoerfer" <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Bytea/Base64 encoders for libpq - interested? |
Date: | 2001-09-04 04:55:23 |
Message-ID: | 016101c134fd$ce757920$0705a8c0@jecw2k1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
> > It might be nice to have a PQbyteaEscape or some such function available
in
> > the libpq client library so that arbitrary binary could be escaped on
the
> > client side and used in a sql statement. I actually wrote this already
as an
> > addition to the PHP PostgreSQL extension, but it would make more sense,
now
> > that I think about it, for it to be in libpq and called from PHP (or
> > whatever). Comments?
>
> Good idea. I will commit the non-bytea escape in a day and you can base
> a bytea one on that. You will have to pass in the length of the field
> because of course it is not null terminated.
OK.
>
> > On a related note, are there any other bytea functions we should have in
the
> > backend before freezing for 7.2? I was thinking it would be nice to have
a
> > way to cast bytea into text and vice-versa, so that the normal text
> > functions could be used for things like LIKE and concatenation. Any
interest
> > in this? If so, any guidance WRT how it should be implemented?
>
> I can't see why you can't do that. The only problem is passing a \0
> (null byte) back to the client.
Well, ISTM the simplest (if not the most efficient) way to do bytea-to-text
would be a function that takes the escaped string value from byteaout, and
creates a text value directly from it. The only danger I can think of is
that very long strings might need to be truncated in length, since the
escaped string could be significantly longer than the binary.
Text-to-bytea should be a straight copy, since nothing that can be
represented as text cannot be represented as bytea.
Any comments or concerns?
-- Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-09-04 05:00:49 | Re: [PATCH] [LARGE] select * from cursor foo |
Previous Message | Bruce Momjian | 2001-09-04 04:54:50 | Re: Re: Toast,bytea, Text -blob all confusing |
From | Date | Subject | |
---|---|---|---|
Next Message | Vsevolod Lobko | 2001-09-04 06:09:54 | Re: Patch for pl/tcl Tcl_ExternalToUtf and Tcl_UtfToExternal |
Previous Message | Barry Lind | 2001-09-04 04:46:13 | Re: Read transactions don't work on 7.0.x db's |