Re: Mysql -> PgSQL

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