From: Sugandha Shah <Sugandhas@cybage.com>
To: Janning Vygen <vygen@gmx.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Function error
Date: Tue, 13 Aug 2002 12:58:41 +0530
Message-ID: <008c01c2429b$0c6a1c80$2005a8c0@cybage.com> (raw)
References: <002a01c2428f$96de9000$2005a8c0@cybage.com>
<200208130701.g7D71UF20185@janning.planwerk6.local>
Hi ,
Thanx a lot it worked .
Is there any equivalent of dateadd function in postgres ?
Regards,
-Sugandha
----- Original Message -----
From: "Janning Vygen" <vygen@gmx.de>
To: "Sugandha Shah" <Sugandhas@cybage.com>; <pgsql-sql@postgresql.org>
Sent: Tuesday, 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 executing PL/pgSQL function
> > sel_free_disk_space line 7 at SQL statement
> > SELECT query has no destination for result data.
> > If you want to discard the results, use PERFORM instead.
>
> you need to SELECT INTO if you want to set a varaible in plpgsql
>
> try this:
> DECLARE
> var_free integer;
> -- var_free is used just to name it differently from the column name
> BEGIN
> SELECT INTO var_free
> free from logical_drive where computer_id = $1 and
> letter = upper($2);
> IF var_free THEN
> ...
>
>
> Janning
>
> > CREATE FUNCTION sel_free_disk_space(int4,bpchar) RETURNS integer
> > AS ' DECLARE
> > -- Declare variable to store the free space.
> > free INTEGER;
> >
> > BEGIN
> > select free from logical_drive where computer_id = $1 and
> > letter = upper($2);
> > IF free IS NULL THEN
> > RETURN -1;
> > END IF;
> >
> > RETURN free;
> > END;
> > 'LANGUAGE 'plpgsql';
> >
> >
> > I'm not able to understand what I'm missing ?
> >
> > Secondly is there any equivalent of exec for postgres ?
> >
> > Any help will be highly appreciated.
> >
> > Regards,
> > -Sugandha
>
> --
> Planwerk 6 /websolutions
> Herzogstraße 86
> 40215 Düsseldorf
>
> fon 0211-6015919
> fax 0211-6015917
> http://www.planwerk6.de
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Sugandhas@cybage.com, vygen@gmx.de
Subject: Re: Function error
In-Reply-To: <008c01c2429b$0c6a1c80$2005a8c0@cybage.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox