Re: [GENERAL] What is the good equivalent for ENUM ?

2003-09-03 Thread Ron Johnson
On Wed, 2003-09-03 at 09:50, Vivek Khera wrote: > > "SD" == Shridhar Daithankar <[EMAIL PROTECTED]> writes: > > SD> On 3 Sep 2003 at 14:30, Bruno BAGUETTE wrote: > >> The problem is that this MySQL database uses ENUM, do you see what can I > >> do to migrate ENUM into PostgreSQL ? > > SD> var

Re: [GENERAL] What is the good equivalent for ENUM ?

2003-09-03 Thread Dennis Gearon
that's how I'd do it, since in reality, that's all an ENUM is, is a mini foreign table internalized onto a column in another table. Vivek Khera wrote: "SD" == Shridhar Daithankar <[EMAIL PROTECTED]> writes: SD> On 3 Sep 2003 at 14:30, Bruno BAGUETTE wrote: The problem is that thi

Re: [GENERAL] What is the good equivalent for ENUM ?

2003-09-03 Thread Vivek Khera
> "SD" == Shridhar Daithankar <[EMAIL PROTECTED]> writes: SD> On 3 Sep 2003 at 14:30, Bruno BAGUETTE wrote: >> The problem is that this MySQL database uses ENUM, do you see what can I >> do to migrate ENUM into PostgreSQL ? SD> varchar with check constraints. Add constraits to allow only SD>