Re: EVAL and SET equivalents in PostgreSQL

I just noticed this in Freshmeat - it may be helpful.

    "Perl utility to convert MySQL dumps into Postgres dump.
     (MySQL and Postgres are the most popular and advanced
     open-source database engines.) Emulates ENUMs and
     SETs via user types and operators."

    "Since version 7.1beta5, my2pg is a part of Postgres
     distribution and can be found in the collection of
     contributed code under contrib/mysql directory."

     http://ziet.zhitomir.ua./~fonin/code/



cjs@cynic.net (Curt Sampson) wrote in message news:<Pine.NEB.4.44.0207050915111.22637-100000@angelic.cynic.net>...
> On Wed, 3 Jul 2002, Lynn David Newton wrote:
>
> > No one who has responded (four people so far) has yet
> > quite hit the nail on the head regarding a substitute
> > for MySQL's SET data type.
>
> Well, as someone else pointed out, there's always the option of
> doing it the relational way, and just creating a separate table
> for this.
>
> However, if you want to do what MySQL does internally, and do it
> in a more portable way, you can just use bitfields in an int or
...