From: Matthew Hagerty <matthew@venux.net>
To: pgsql-interfaces@postgreSQL.org
Subject: (libpq question) Holy cow, what's all this fluff?!
Date: Sat, 13 Feb 1999 18:35:20 -0500
Message-ID: <4.1.19990213182304.0095d400@mail.venux.net> (raw)
Greetings,
When using the PQgetvalue() function of libpq, the results, at least char
fields, return the value in full, i.e. a char(20) field with the text
"Matthew" for example returns "Matthew " (all 20 characters,
padded with spaces).
I'm sure there is a good reason for this? But, none the less, I would like
to turn it off if I can, otherwise I'm off to writing a small function to
strip the spaces off. This is kind of a pain though because I don't need
to modify the values, just display them, or fill a browser's form fields
with values from the database (which is my biggest need to strip the
fluff). The docs say that I should not access the structure holding query
results, so I will have to malloc each value, copy it, strip the fluff,
send it out on its way, and release the memory. More housekeeping, yuck!
Not to mention more processing time. Please tell me there is a way to get
field values with libpq that are exact to the content length and not the
field length.
Thanks,
Matthew
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: matthew@venux.net
Subject: Re: (libpq question) Holy cow, what's all this fluff?!
In-Reply-To: <4.1.19990213182304.0095d400@mail.venux.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox