Re: [SQL] Failing join with set returning function

2007-09-07 Thread [EMAIL PROTECTED]
Please, remove my address from this Mailing List. thanks -- Leggi GRATIS le tue mail con il telefonino i-modeĀ™ di Wind http://i-mode.wind.it/

[SQL] Failing join with set returning function

2007-09-07 Thread Bart Degryse
I've written a function that calculates the number of days for every month in a given range and returns that as a set of records. CREATE OR REPLACE FUNCTION general_daysinmonth( date1 IN date, date2 IN date, month OUT date, days OUT integer) RETURNS SETOF record AS $body$ DECLARE startda