Tags: converting, database, fetching, fetchingis, informix, mysql, onequestion, oracle, postgre, postgresql, record, records, sql, variable, working

Variable record fetching

On Database » PostgreSQL

1,088 words with 0 Comments; publish: Mon, 26 May 2008 09:55:00 GMT; (25063.48, « »)


I am working on converting Informix database to Postgre. I have one

question for fetching records using PostgreSQL. The record I am fetching

is a variable size text string. Before fetching the record, a

preallocated static buffer size will have to be declared beforehand in

the declaration section. Since the record sizes vary a lot, instead of

using the static buffer, is there a dynamic way to fetch these records?

Informix (Oracle has the similar feature) has the locator variable and

the server will allocate the buffer if you initiate the locator to

accommodate the record. The application then checks the locator size

(record.loc_bufsize) to dynamically allocate a buffer to fetch it out

and free the locator buffer. Does Postgre have any way to pre-tell the

size of returning record? Thanks.

Shujun Huang

--(end of broadcast)--

TIP 3: if posting/reading through Usenet, please send an appropriate

subscribe-nomail command to majordomo.postgresql.todaysummary.com.postgresql.org so that your

message can get through to the mailing list cleanly

All Comments

Leave a comment...