Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4B80B47603D for ; Thu, 19 Sep 2002 10:11:17 -0400 (EDT) Received: from ws2.hk5.outblaze.com (202-77-181-84.outblaze.com [202.77.181.84]) by postgresql.org (Postfix) with SMTP id 680DB475FD5 for ; Thu, 19 Sep 2002 10:11:15 -0400 (EDT) Received: (qmail 13403 invoked by uid 1001); 19 Sep 2002 14:11:17 -0000 Message-ID: <20020919141116.13398.qmail@graffiti.net> Content-Type: text/plain; charset="iso-8859-15" Content-Disposition: inline Content-Transfer-Encoding: 7bit Mime-Version: 1.0 X-Mailer: MIME-tools 4.104 (Entity 4.117) Received: from [211.22.33.144] by ws2.hk5.outblaze.com with http for cnliou@graffiti.net; Thu, 19 Sep 2002 22:11:13 +0800 From: "CN LIOU" To: pgsql-sql@postgresql.org Date: Thu, 19 Sep 2002 22:11:13 +0800 Subject: How To Get Bytea Data Instead Of Its Oid X-Originating-Ip: 211.22.33.144 X-Originating-Server: ws2.hk5.outblaze.com X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/215 X-Sequence-Number: 9492 Greetings! I must have missed lesson 1 of postgresql! create table test (c1 text,c2 bytea); Then, I probably have successfullyi nserted several records into test using C++Builder. Now I am trying to retrieve back the binary data in c2 I just inserted. However, the SQL statement issued by both C++Builder and psql: SELECT * FROM test LIMIT 1 returns, I guess, the OID of c2 instead of the binary data to which the OID points. What is the correct SQL syntax for C++Builder for bytea? Regards, -- _______________________________________________ Get your free email from http://www.graffiti.net Powered by Outblaze