Re: bug in working with TEXT constants ?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
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:11:51
Message-ID: 20031028070734.P60098@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 28 Oct 2003, sad wrote:

> Good day.
>
> AFAIK PostgreSQL provides the type TEXT with 4-byte prefix length
> which is distinct to C's zero-terminated (char *)
> That's very good.
> Then I expect natural possibility to store texts having zero characters.

If you want to store zero characters (or binary data) you
probably want bytea not text.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-10-28 15:41:34 Re: bug in working with TEXT constants ?
Previous Message SZŰCS Gábor 2003-10-28 15:08:51 numeric and float converts to int differently?