[GENERAL] pl/pgsql function with argument of type DATE

[Bojan]

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