Re: bug in working with TEXT constants ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sad <sad(at)bankir(dot)ru>
Cc: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: bug in working with TEXT constants ?
Date: 2003-10-28 15:41:34
Message-ID: 22445.1067355694@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

sad <sad(at)bankir(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-10-28 15:43:12 Re: URGENT!!! changing Column size
Previous Message Stephan Szabo 2003-10-28 15:11:51 Re: bug in working with TEXT constants ?