pl/pgsql function with argument of type DATE
От
Bojan
Тема
pl/pgsql function with argument of type DATE
Дата
Msg-id
000801c8cb1b$b36c64c0$1a452e40$@com
Список
Дерево обсуждения
pl/pgsql function with argument of type DATE "Bojan" <bojank@brandcomms.com>
Re: pl/pgsql function with argument of type DATE "Pavel Stehule" <pavel.stehule@gmail.com>
Re: pl/pgsql function with argument of type DATE "A. Kretschmer" <andreas.kretschmer@schollglas.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)
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 по дате отправления