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 23DCB9DCC2A for ; Mon, 20 Mar 2006 08:00:25 -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 60435-05 for ; Mon, 20 Mar 2006 08:00:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id 7C8B89DCB4E for ; Mon, 20 Mar 2006 08:00:22 -0400 (AST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k2KD6BOp022876; Mon, 20 Mar 2006 15:06:11 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id k2KD6BA9022872; Mon, 20 Mar 2006 15:06:11 +0200 Date: Mon, 20 Mar 2006 15:06:11 +0200 (EET) From: Achilleus Mantzios To: Peter Eisentraut cc: "Eugene E." , Subject: Re: have you feel anything when you read this ? In-Reply-To: <200603201251.11255.peter_e@gmx.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200603/293 X-Sequence-Number: 24639 O Peter Eisentraut έγραψε στις Mar 20, 2006 : > Eugene E. wrote: > > the bytea does not output NULs at all. > > don't mock me. > > peter=# create table test (a bytea); > CREATE TABLE > peter=# insert into test values ('a\\000b'); > INSERT 0 1 > peter=# select * from test; > a > -------- > a\000b Just did dynacom=# SELECT '\150\145\154\154\157'::text; text ------- hello (1 row) dynacom=# dynacom=# dynacom=# SELECT '\000\150\145\154\154\157'::text; text ------ (1 row) dynacom=# Oops! > > -- -Achilleus