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....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | MSN.......: B_G_Allie@email.msn.com
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |