Re: getting no days problem

From: Thom Brown <thombrown(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: getting no days problem
Date: 2009-01-29 10:55:21
Message-ID: bddc86150901290255y2daf0056r43f7cce2eb6e18ef@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/1/29 sanjeev kumar <vannalaspgsql(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2009-01-29 11:39:30 Re: Slow first query despite LIMIT and OFFSET clause
Previous Message sanjeev kumar 2009-01-29 10:31:06 getting no days problem