Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D10EB476AFE for ; Thu, 19 Sep 2002 12:46:50 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 26A53476852 for ; Thu, 19 Sep 2002 12:46:50 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8JGkd5D026881; Thu, 19 Sep 2002 12:46:39 -0400 (EDT) To: "CN LIOU" Cc: pgsql-sql@postgresql.org Subject: Re: How To Get Bytea Data Instead Of Its Oid In-reply-to: <20020919141116.13398.qmail@graffiti.net> References: <20020919141116.13398.qmail@graffiti.net> Comments: In-reply-to "CN LIOU" message dated "Thu, 19 Sep 2002 22:11:13 +0800" Date: Thu, 19 Sep 2002 12:46:38 -0400 Message-ID: <26880.1032453998@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/222 X-Sequence-Number: 9499 "CN LIOU" writes: > SELECT * FROM test LIMIT 1 > returns, I guess, the OID of c2 instead of the binary data to which the OID points. I don't think so... regression=# create table test (c1 text,c2 bytea); CREATE TABLE regression=# insert into test values ('some text', 'some binary data \\000\\001'); INSERT 284058 1 regression=# select * from test; c1 | c2 -----------+--------------------------- some text | some binary data \000\001 (1 row) I see no OID here. Perhaps you should show us an example of what you are doing, rather than your interpretation of what's going wrong. regards, tom lane