X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 324C7D1B51A for ; Tue, 28 Oct 2003 15:12:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 04679-05 for ; Tue, 28 Oct 2003 11:11:57 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 23683D1B4F4 for ; Tue, 28 Oct 2003 11:11:53 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 185F8352CE; Tue, 28 Oct 2003 07:11:51 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 15155352B6; Tue, 28 Oct 2003 07:11:51 -0800 (PST) Date: Tue, 28 Oct 2003 07:11:51 -0800 (PST) From: Stephan Szabo To: sad Cc: psql Subject: Re: bug in working with TEXT constants ? In-Reply-To: <200310281153.54160.sad@bankir.ru> Message-ID: <20031028070734.P60098@megazone.bigpanda.com> References: <200310281153.54160.sad@bankir.ru> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/365 X-Sequence-Number: 15765 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.