Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 89893475A00 for ; Tue, 13 Aug 2002 03:26:27 -0400 (EDT) Received: from herald.cybage.com (unknown [203.124.129.210]) by postgresql.org (Postfix) with ESMTP id C2F57475FFA for ; Tue, 13 Aug 2002 03:26:23 -0400 (EDT) Received: from Sugandha ([192.168.5.32]) by herald.cybage.com with Microsoft SMTPSVC(5.0.2195.4453); Tue, 13 Aug 2002 12:58:41 +0530 Message-ID: <008c01c2429b$0c6a1c80$2005a8c0@cybage.com> From: "Sugandha Shah" To: "Janning Vygen" Cc: References: <002a01c2428f$96de9000$2005a8c0@cybage.com> <200208130701.g7D71UF20185@janning.planwerk6.local> Subject: Re: Function error Date: Tue, 13 Aug 2002 12:58:41 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-OriginalArrivalTime: 13 Aug 2002 07:28:41.0516 (UTC) FILETIME=[0C65D6C0:01C2429B] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/200 X-Sequence-Number: 9046 Hi , Thanx a lot it worked . Is there any equivalent of dateadd function in postgres ? Regards, -Sugandha ----- Original Message ----- From: "Janning Vygen" To: "Sugandha Shah" ; 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 >