Re: bug in working with TEXT constants ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: bug in working with TEXT constants ?
Date
Msg-id 22445.1067355694@sss.pgh.pa.us
Whole thread Raw
In response to bug in working with TEXT constants ?  (sad <sad@bankir.ru>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: bug in working with TEXT constants ?
Next
From: Tom Lane
Date:
Subject: Re: numeric and float converts to int differently?