Re: Mysql -> PgSQL

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

On Thursday 22 August 2002 10:54 pm, Tommi Maekitalo wrote:
> > > Thats not so trivial. The type set can have "zero or more values, each
> > > of which must be chosen from a list of allowed values" (from
> > > Mysql-manual). In PostgreSQL you have to use a details-table for this.
> > > This is a nonstandard feature of Mysql (these people concentrate in
> > > creating nonstandard extensions before supporting the full standard ;-)
> >
> > Oh, yes, it is enum that is CHECK. 'set' has multiple values. It is a
> > nifty MySQL feature, I must say.
>
> But not so tricky as it looks first. They use just a bitmask for it. The
> maximum number of allowed values is limited to 64 so it must be a 8-Byte
> bitmask.
>
> What do you think? Wouldn't it be nice to have this feature? It shouldn't
> be too hard to implement it.
>
> Tommi
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)