Re: [Pypgsql-users] pyPgSQL/Quixote data cursor browse form
"Billy G. Allie" <[email protected]>
| Newsgroups | gmane.comp.web.quixote.user,gmane.comp.python.db.pypgsql.user |
|---|---|
| Organization | michigan!/usr/group |
| Message-ID | <[email protected]> |
Benjamin Scherrey wrote: >[...] > One last thing I noticed is that pyPgSQL reports a size of 4 for integer types which is >really bad because this means I can't enter in a filter of greater than 4 characters for integer fields. >This comes from the cursor.decription of the select results. Anyone recommend a good way to deal >with this? Is it a pyPgSQL anomoly or is the 4 supposed to be interpreted differently for integers? > > > Ben, The [intrnal] size of an integer is always 4 bytes for an integer (a 32 bit value). The display size for an Integer can be up to 10 charachters, but PostgreSQL no longer returns the display size. Other numberic fields (float, int8, int2) will have fixed sizes representing the number of bytes used to store the value internally in the database. I hope this clears up the issue. -- ___________________________________________________________________________ ____ | Billy G. Allie | Domain....: [email protected] | /| | 7436 Hartwell | MSN.......: [email protected] |-/-|----- | Dearborn, MI 48126| |/ |LLIE | (313) 582-1540 |