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.
Here is the MS -SQL stored procedure :
CREATE procedure sel_free_disk_space
@computer_id int,
@letter char(1)
as
declare @free int
select @free = [free]
from logical_drive
where computer_id = @computer_id
and letter = upper(@letter)
if (@free is null)
set @free = -1
return @free
GO
Here is the equivalent function for Postgres :
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