Re: pl/pgsql function with argument of type DATE - Mailing list pgsql-general

2008/6/10 Bojan <bojank@brandcomms.com>:
> 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)

it's nonsense :) you call foo with values (2001, 1993)

Pavel
>
> 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
>