pl/pgsql function with argument of type DATE

From: "Bojan" <bojank(at)brandcomms(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pl/pgsql function with argument of type DATE
Date: 2008-06-10 17:02:01
Message-ID: 000801c8cb1b$b36c64c0$1a452e40$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leif B. Kristensen 2008-06-10 17:09:27 Re: REGEXP_REPLACE woes
Previous Message Tatsuo Ishii 2008-06-10 16:56:31 Re: [ANNOUNCE] PostgreSQL Software Catalogue