Hello,
I have the following plpgsql function the output are 3 values. i need to insert
these values to the table.
when i run the function, only the first value of the result are inserted
how i can insert the rest of the result to the table
CREATE OR REPLACE FUNCTION eehab(integer) RETURNS integer AS
declare
mypoint alias for $1;
myresult integer;
begin
select into myresult distinct o from ramadan where o=mypoint or
a=mypoint union select distinct a from ramadan where o=mypoint or a=mypoint;
insert into eehab values (myresult);
return myresult;
end;
'LANGUAGE 'plpgsql'
kind regards
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
