How To Get Bytea Data Instead Of Its Oid

Поиск
Список
Период
Сортировка
От CN LIOU
Тема How To Get Bytea Data Instead Of Its Oid
Дата
Msg-id 20020919141116.13398.qmail@graffiti.net
обсуждение исходный текст
Ответы Re: How To Get Bytea Data Instead Of Its Oid
Список pgsql-sql
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
backthe 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Thorbjörn Eriksson
Дата:
Сообщение: Re: Stripping white-space in SELECT statments
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Index usage on date feild , differences in '>' and '>='