Thread

Re: [HACKERS] wishlist: PQfsize

Edmund Mergl <e.mergl@bawue.de> — 1998-02-15T06:46:35Z

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