Mike Christensen wrote:
According to the manuals, Postgres has smallint (2 byte), integer (4
bytes) and bigint (8 bytes).. I use a lot of structures with "bytes"
in my code and it's kinda annoying to cast DB output from Int16 to
Byte every time, especially since there's no explicit cast in .NET and
you have to use System.Convert().
Is there a work-around, or do people just cast or use Int16 in their
data structures? Just wondering.. I know on modern computers it
probably doesn't make any difference anyway..
Is this just about programmer convenience or is it about space efficiency in the
database? BYTEA might help you. Or try declaring a DOMAIN over SMALLINT that
limits allowed values to the range of a byte. -- Darren Duncan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
