I have added the following TODO item on protocol changes: > * Wire Protocol Changes > o Show transaction status in psql > o Allow binding of query parameters, support for prepared queries > o Add optional textual message to NOTIFY > o Remove hard-coded limits on user/db/password names > o Remove unused elements of startup packet (unused, tty, passlength) > o Fix COPY/fastpath protocol? > o Replication support? > o Error codes > o Dynamic character set handling > o Special passing of binary values in platform-neutral format (bytea?) > o ecpg improvements? > o Add decoded type, length, precision
--------------------------------------------------------------------------- snpe wrote: > 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 > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
