"CN LIOU" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
