[postgis-users] Plpgsql function

[eehab hamzeh]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090219/774310b1/attachment.html>