pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Radu-Adrian Popescu <radu.popescu@www.aldratech.com>
Cc: csawtell@paradise.net.nz
Cc: pgsql-sql@postgresql.org
Subject: Re: How to use BYTEA type?
Date: Thu, 1 Nov 2001 08:22:51 -0800 (PST)
Message-ID: <20011101081044.G22509-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3BE120D1.3060406@www.aldratech.com>


On Thu, 1 Nov 2001, Radu-Adrian Popescu wrote:

> Doing
>
> template1=> SELECT proname from pg_proc ;
>         proname
> ------------------------
>  boolin
>  boolout
>  byteain
>  byteaout
>
> you can see there is a byteaout function also. However, these are
> undocumented in the interactive docs, which is a shame indeed. I only
> learned of byteain/out after reading your email.
>
> If some of the postgresql guys could point the location of the
> documentation of undocumented functions  :-)  that'd be great.

AFAIK, the in and out functions are *not* meant to be called by
users.  They're used by the system and I think they technically
take pointer values.  To use bytea correctly, I believe you are
supposed to do some escaping and place the value into the
insert statement.

insert into table values ('\011\005\\000afkajdd\011');
(note the double backslash on the null byte).  And you should
get the value back from a straight select on the column I believe.





view thread (4+ messages)  latest in thread

Message-ID: <20011101081044.G22509-100000@megazone23.bigpanda.com>
Permalink:  ../20011101081044.G22509-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20011101081044.G22509-100000@megazone23.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sszabo@megazone23.bigpanda.com, radu.popescu@www.aldratech.com, csawtell@paradise.net.nz
  Subject: Re: How to use BYTEA type?
  In-Reply-To: <20011101081044.G22509-100000@megazone23.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox