Skip site navigation (1) Skip section navigation (2)

Bytea docs (was Re: [PATCHES] bytea datatype documentation patch)

From: Joe Conway <joseph(dot)conway(at)home(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Bytea docs (was Re: [PATCHES] bytea datatype documentation patch)
Date: 2001-11-20 22:26:02
Message-ID: 3BFAD87A.7090605@home.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
[ redirected from patches to pgsql-docs ]

Peter Eisentraut wrote:

> I feel that basing the whole discussion on what "ASCII" characters can be
> stored, are nonprintable, must be escaped, etc. is not appropriate.
> Bytea doesn't store characters, it stores bytes (or octets, as you wish).
> The correspondence between bytes and characters is old-fashioned and
> pretty much does not exist in SQL except for a few places such as
> OCTET_LENGTH.
> 
> Conversely, the discussion about whether text should be able to cope with
> zero bytes is nonsensical because text stores characters and not bytes.
> 
> So I would base this discussion on the premise "bytea stores binary data"
> (insert examples).


Thanks for the input, Peter.

I was struggling to come up with a better way to say, for example "ASCII 
value XX", that would be clear to the reader. Do you think referring to 
"bytes of decimal value XX" is better?

I'll take another stab at this with your guidance in mind.


> 
> Some stylistic issues:
> 
> bytea => <type>bytea</type>
> 
> NULLs => zero bytes/bytes of value zero ("NULL" is too overloaded)
> 
> 'non-printable' => <quote>nonprintable</quote>
> 
> MUST => <emphasis>must</emphasis>
> 

Good input -- I'll fix these too.

Thanks!

-- Joe


In response to

pgsql-docs by date

Next:From: Joe ConwayDate: 2001-11-20 23:02:55
Subject: Re: Cross-references (was [PATCHES] PQescapeBytea documentation patch)
Previous:From: Peter EisentrautDate: 2001-11-20 21:42:26
Subject: Re: bytea datatype documentation patch

pgsql-patches by date

Next:From: Joe ConwayDate: 2001-11-20 23:02:55
Subject: Re: Cross-references (was [PATCHES] PQescapeBytea documentation patch)
Previous:From: Peter EisentrautDate: 2001-11-20 21:42:26
Subject: Re: bytea datatype documentation patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group