Converting MySQL tinyint to PostgreSQL

From: Joe <svn(at)freedomcircle(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Converting MySQL tinyint to PostgreSQL
Date: 2005-07-12 05:16:07
Message-ID: 42D35217.5050802@freedomcircle.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a MySQL database that I'm converting to PostgreSQL which has 10 columns
with TINYINT type, i.e., a one-byte integer. Only one of them qualifies as a
true BOOLEAN. Two are entity identifiers (for limited range "classes" or
"categories") and three others are "type"/code values. The last four are month
numbers or day of month numbers (not implemented as date types because the year
is separate and is part of the primary key).

I'm wondering what would be the best conversion choice for these columns:
smallint, numeric(1), char(1), something else? AFAICT, the application does not
directly do any arithmetic on these columns, but the identifier and code types
are used as indices into PHP arrays. The month/day values are formatted into
dates for display (and the month also servers as an index into a month-name array).

BTW, is TINYINT part of any SQL Standard?

Joe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marco Gaiarin 2005-07-12 08:19:37 7.2 -> 7.4: horrible performance hit!
Previous Message TJ O'Donnell 2005-07-12 03:16:17 dynamically loaded functions