Postgres Pro
Downloads
Home   >   mailing lists

Re: getting no days problem - Mailing list pgsql-general

From Thom Brown
Subject Re: getting no days problem
Date
Msg-id bddc86150901290255y2daf0056r43f7cce2eb6e18ef@mail.gmail.com
Whole thread Raw
In response to getting no days problem  (sanjeev kumar <vannalaspgsql@gmail.com>)
List pgsql-general
Tree view
2009/1/29 sanjeev kumar <vannalaspgsql@gmail.com>

Hi all,

I have written procedure as follows:
---------------------------------------------------------
--procedure begin
Create Procedure sp_getNoOfDays(
                         ip_startDate    IN date,
                         ip_endDate      IN date,
                         op_noofdays     OUT bigint
                        )
i

Create Procedure?  Are you sure this isn't for Oracle?  Shouldn't this be a function?

Thom

pgsql-general by date:

Previous
From: sanjeev kumar
Date:
Subject: getting no days problem
Next
From: Gregory Stark
Date:
Subject: Re: Slow first query despite LIMIT and OFFSET clause