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

Re: Re: Toast,bytea, Text -blob all confusing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Joe Conway <joseph(dot)conway(at)home(dot)com>, Alex Pilosov <alex(at)acecape(dot)com>, Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Toast,bytea, Text -blob all confusing
Date: 2001-09-04 04:52:15
Message-ID: 24943.999579135@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> However, there's a trap: before things get to bytea input handler, they
> are first processed by postgresql general parser.

This description fails to make clear that the two levels of parsing only
apply for datums that are written as string literals in SQL commands.
An example where this doesn't apply is COPY input data.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-09-04 04:54:50
Subject: Re: Re: Toast,bytea, Text -blob all confusing
Previous:From: Tom LaneDate: 2001-09-04 04:45:05
Subject: Re: Bytea/Base64 encoders for libpq - interested?

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