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

From Bojan
Subject pl/pgsql function with argument of type DATE
Date
Msg-id 000801c8cb1b$b36c64c0$1a452e40$@com
Whole thread Raw
Responses Re: pl/pgsql function with argument of type DATE  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: pl/pgsql function with argument of type DATE  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List 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

pgsql-general by date:

Previous
From: "wenjing wu"
Date:
Subject: Fw: postgrepsql vacuum
Next
From: askel
Date:
Subject: Re: IN vs EXISTS