On Thursday 07 November 2002 09:50 pm, korry wrote: > > > b) Send a decoded version of atttypmod - specifically, decode the > > > precision and scale for numeric types. > > > >I want decode type,length,precision and scale > > Type is returned by PQftype(), length is returned by PQfsize(). Precision > and scale are encoded in the return value from PQfmod() and you have to > have a magic decoder ring to understand them. (Magic decoder rings are > available, you just have to read the source code :-) > > PQftype() is not easy to use because it returns an OID instead of a name > (or a standardized symbol), but I can't think of anything better to return > to the client. Of course if you really want to make use of PQftype(), you > can preload a client-side cache of type definitions. I seem to remember > seeing a patch a while back that would build the cache and decode precision > and scale too. > > PQfsize() is entertaining, but not often what you really want (you really > want the width of the widest value in the column after conversion to some > string format - it seems reasonable to let the client applicatin worry > about that, although maybe that would be a useful client-side libpq > function). > > I want this in any catalog view
regards Haris Peco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly