Re: Mysql -> PgSQL

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tommi Maekitalo <t(dot)maekitalo(at)epgmbh(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Mysql -> PgSQL
Date: 2002-08-23 15:29:33
Message-ID: 200208231529.g7NFTXj07978@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


What the SQL standard wants you to do with SETs is to create another
table to hold the codes, and another table to hold the relationships
between the master table rows and the values.

We do have an array type that may work in such cases, though the array
type is ordered and doesn't have pre-defined values for the elements.

---------------------------------------------------------------------------

Tommi Maekitalo wrote:
> Am Freitag, 23. August 2002 09:41 schrieb Jeff Davis:
> > Another question that comes to mind is: are there any plans to allow
> > user-defined types to accept argument lists? If that were the case, this
> > wouldn't be much of an issue, because anyone could just make a set type. As
> > it is, I think it needs to be added as a special case.
> >
> > Regards,
> > Jeff
> >
>
> That brings me to an idea. You can write a function, which converts a list of
> strings to a bitmask and stores this value. Then it should be possible to
> write something like
>
> insert into table(..., my_set) values (..., set('val1', 'val2', 'val3'))
>
> as the original poster inteded to do. You need then a set of functions, for
> queriing the values.
>
> I'm not so familiar with udfs in postgresql. Is it possible to write udfs with
> a variable number of arguments? Or is it possible to give a array-parameter
> to a udf.
>
> Mysqls set-type is still much more comfortable. Udfs is not a feature the
> average Mysql-user wants to use.
>
>
> Tommi
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-08-23 15:37:16 Re: How to retrieve a comment/description from a table
Previous Message Peter Gibbs 2002-08-23 15:23:17 Re: How to retrieve a comment/description from a table