From: Janning Vygen <vygen@gmx.de>
To: Sugandha Shah <Sugandhas@cybage.com>
To: pgsql-sql@postgresql.org
Subject: Re: Function error
Date: Tue, 13 Aug 2002 09:01:30 +0200
Message-ID: <200208130701.g7D71UF20185@janning.planwerk6.local> (raw)
In-Reply-To: <002a01c2428f$96de9000$2005a8c0@cybage.com>
References: <002a01c2428f$96de9000$2005a8c0@cybage.com>
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: vygen@gmx.de, Sugandhas@cybage.com
Subject: Re: Function error
In-Reply-To: <200208130701.g7D71UF20185@janning.planwerk6.local>
* 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