Hi ,
I'm porting MS- SQL stored procedure to postgres
. I'm getting this error :
Error occurred while executing PL/pgSQL
function sel_free_disk_space line 7 at SQL statementSELECT query
has no destination for result data.If you want to discard the results, use
PERFORM instead.
Here is th
Am Dienstag, 13. August 2002 08:06 schrieb Sugandha Shah:
> Hi ,
>
> I'm porting MS- SQL stored procedure to postgres . I'm getting this
> error :
>
> Error occurred while executing PL/pgSQL function
> sel_free_disk_space line 7 at SQL statement
> SELECT query has no destination for result data.
>
, August 13, 2002 12:31 PM
Subject: Re: [SQL] Function error
> Am Dienstag, 13. August 2002 08:06 schrieb Sugandha Shah:
> > Hi ,
> >
> > I'm porting MS- SQL stored procedure to postgres . I'm getting this
> > error :
> >
> > Error occurred while execu
> Hi ,
>
> Thanx a lot it worked .
>
> Is there any equivalent of dateadd function in postgres ?
I highly recommend you actually read the Postgres manual's entries on date
and time manipulation.
You can just add intervals to dates:
SELECT datefield + INTERVAL '1 month';
Chris
---