equivalent of mysql's SET type?

From: Reece Hart <reece(at)harts(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: equivalent of mysql's SET type?
Date: 2011-03-09 01:06:40
Message-ID: AANLkTim5qy0+KSYk3YvsKdYU2fbehhwDG-1D5Kg71Sbe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm considering porting a MySQL database to PostgreSQL. That database uses
MySQL's SET type. Does anyone have advice about representing this type in
PostgreSQL?

MySQL DDL excerpt:
CREATE TABLE `transcript_variation` (
`transcript_variation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`transcript_stable_id` varchar(128) NOT NULL,
...
`consequence_type`
set('ESSENTIAL_SPLICE_SITE','STOP_GAINED','STOP_LOST','COMPLEX_INDEL','SPLICE_SITE')
) ENGINE=MyISAM AUTO_INCREMENT=174923212 DEFAULT CHARSET=latin1;

I'm considering implementing this as a new type based on a bit vector, but I
wonder if anyone has a more flexible general solution.

Thanks,
Reece

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2011-03-09 01:51:50 Re: equivalent of mysql's SET type?
Previous Message David Johnston 2011-03-09 01:00:34 Re: Using bytea field...