By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,742 Members | 1,033 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,742 IT Pros & Developers. It's quick & easy.

Variable record fetching

P: n/a
Hi,

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 ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.