Joe <[EMAIL PROTECTED]> writes:
> I have a MySQL database that I'm converting to PostgreSQL which has 10
> columns
> with TINYINT type, i.e., a one-byte integer.
> I'm wondering what would be the best conversion choice for these columns:
> smallint, numeric(1), char(1), something else?
smallint, for sure; the others have more overhead.
> BTW, is TINYINT part of any SQL Standard?
No. If it were, we'd feel more urgency about implementing it ;-)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
