X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id DB8939DC812
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 20 Mar 2006 08:13:54 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 64073-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 20 Mar 2006 08:13:57 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180])
	by postgresql.org (Postfix) with ESMTP id 4B05E9DC852
	for <pgsql-sql@postgresql.org>; Mon, 20 Mar 2006 08:13:51 -0400 (AST)
Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165])
	by mx1.surnet.cl with ESMTP; 20 Mar 2006 08:13:55 -0400
X-IronPort-AV: i="4.03,110,1141614000";
	d="scan'208"; a="47677866:sNHT17959192"
Received: from alvh.no-ip.org (201.221.200.13) by cluster.surnet.cl (7.0.043)
	(authenticated as alvherre@surnet.cl)
	id 43A978FD00B25A98; Mon, 20 Mar 2006 08:13:54 -0400
Received: by alvh.no-ip.org (Postfix, from userid 1000)
	id 37A73C45022; Mon, 20 Mar 2006 08:13:54 -0400 (CLT)
Date: Mon, 20 Mar 2006 08:13:54 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, "Eugene E." <sad@bankir.ru>,
	pgsql-sql@postgresql.org
Subject: Re: have you feel anything when you read this ?
Message-ID: <20060320121354.GA12564@surnet.cl>
Mail-Followup-To: Achilleus Mantzios <achill@matrix.gatewaynet.com>,
	Peter Eisentraut <peter_e@gmx.net>, "Eugene E." <sad@bankir.ru>,
	pgsql-sql@postgresql.org
References: <200603201251.11255.peter_e@gmx.net>
	<Pine.LNX.4.44.0603201504250.22800-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.44.0603201504250.22800-100000@matrix.gatewaynet.com>
User-Agent: Mutt/1.5.11+cvs20060126
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=2.172 required=5 tests=[AWL=-0.983,
	DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44,
	RCVD_IN_SORBS_WEB=1.236]
X-Spam-Score: 2.172
X-Spam-Level: **
X-Archive-Number: 200603/294
X-Sequence-Number: 24640

Achilleus Mantzios wrote:

> dynacom=# SELECT '\000\150\145\154\154\157'::text;
>  text
> ------
> 
> (1 row)
> 
> dynacom=#         
> 
> Oops!

text is not bytea.

alvherre=# SELECT $$\000\150\145\154\154\157$$::bytea;
   bytea   
-----------
 \000hello
(1 fila)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.