Added to TODO: o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]
--------------------------------------------------------------------------- Bruno BAGUETTE wrote: > > > CREATE OR REPLACE FUNCTION myownfunction(members.id%TYPE[], > > > events.id%TYPE) RETURNS BOOLEAN AS ' > > > > You can certainly use arrays as arguments, but I don't think > > you can combine %TYPE with [] like that. > > Thanks Tom for the information ! :-) > > When I create functions with %TYPE, PostgreSQL replies that it will > convert the %TYPE with a VARCHAR (for example). So it could replace a > %TYPE[] by a VARCHAR[] (in my example) ? > > It seems that this modification could be done easily, I will try to find > in the source code to create this patch. (Without any warranties, I > never done a patch for PostgreSQL). > > In the meantime, is it possible to add this feature in the TODO list ? > > Regards, > > --------------------------------------- > Bruno BAGUETTE - [EMAIL PROTECTED] > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings