Re: pl/pgsql function with argument of type DATE

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: pl/pgsql function with argument of type DATE
Дата
Msg-id 162867790806120214k26cfdb6en1e876aea816ec66a@mail.gmail.com
обсуждение исходный текст
Ответ на pl/pgsql function with argument of type DATE  ("Bojan" <bojank@brandcomms.com>)
Список 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
>

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: pgAdmin complains about vacuuming required after fresh 8.1 install
Следующее
От: Zoltan Boszormenyi
Дата:
Сообщение: Re: Heavily fragmented table and index data in 8.0.3