Re: EVAL and SET equivalents in PostgreSQL - Mailing list pgsql-general

From nholtz@docuweb.ca (Neal Holtz)
Subject Re: EVAL and SET equivalents in PostgreSQL
Date
Msg-id 639f17f8.0207050230.7af0edcc@posting.google.com
Whole thread Raw
In response to Re: EVAL and SET equivalents in PostgreSQL  (Curt Sampson <cjs@cynic.net>)
List pgsql-general
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
...

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Carraige Return issues
Next
From: "caroline kenny"
Date:
Subject: Re: Carraige Return issues