| 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: | Whole Thread | Raw Message | 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
| 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... |