See this:
“CREATE or replace function geo_polygon(tablename varchar) RETURNS integer
AS $$
DECLARE objectid varchar; tab varchar; x1 float; y1 float; obj_num integer; point_num integer;
polygonstr varchar; cur_obj CURSOR FOR SELECT mrc_xy_position FROM tablename; cur_point CURSOR FOR SELECT
x,yFROM tablename where mrc_xy_position =
objectid;
BEGIN
…….“
Error if call the function. Neither to use “execute” . Who can solve it?
Thanks!
_________________________________________________________________
享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com