From: Tom Lane <tgl@sss.pgh.pa.us>
To: sad <sad@bankir.ru>
Cc: psql <pgsql-sql@postgresql.org>
Subject: Re: bug in working with TEXT constants ?
Date: Tue, 28 Oct 2003 10:41:34 -0500
Message-ID: <22445.1067355694@sss.pgh.pa.us> (raw)
In-Reply-To: <200310281153.54160.sad@bankir.ru>
References: <200310281153.54160.sad@bankir.ru>
sad <sad@bankir.ru> writes:
> Then I expect natural possibility to store texts having zero characters.
You expect wrong; we don't support embedded nulls in text values, nor in
literal strings. You can store nulls in BYTEA fields, but you have to
use bytea's escaping conventions to represent the value in SQL commands,
eg, 'foo\\000bar'.
regards, tom lane
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: tgl@sss.pgh.pa.us, sad@bankir.ru
Subject: Re: bug in working with TEXT constants ?
In-Reply-To: <22445.1067355694@sss.pgh.pa.us>
* 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