Re: [HACKERS] wishlist: PQfsize

Bruce Momjian wrote:

We have a new atttypmod field that holds the length for the column as
defined at table-creation time for char() and varchar(). Is that the
number you want?

--
Bruce Momjian
maillist@candle.pha.pa.us

for varchar() and also for the datatype text it would be
nice to know the actual length. If this is not possible,
then the length at creation time is still better than -1.

If you use binary cursors, you can use VARSIZE and VARDATA to see the
size and data for a string type.

--
Bruce Momjian
maillist@candle.pha.pa.us

For the perl interface (DBD-Pg) I can not use cursors at all,
because they can not be nested.

Edmund
--
Edmund Mergl mailto:E.Mergl@bawue.de
Im Haldenhau 9 http://www.bawue.de/~mergl
70565 Stuttgart fon: +49 711 747503
Germany gsm: +49 171 2645325