pl/pgsql function with argument of type DATE

["Bojan" <bojank@xxxxxxxxxxxxxx>]

How to invoke function which has arguments declared as type “date”?

 

I want to make function which will return a list of all dates between starting and ending

 date which are two arguments of that function. I tried with:

 

select * from foo(2008-06-01, 2008-06-09)

select * from foo(‘2008-06-01’, ‘2008-06-09’)

 

but type mismatch (date vs integer) error occurs.

 

Thanks,

 

     Bojan

 

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.0.0/1486 - Release Date: 05/06/2008 18:29