[postgis-users] function in plpgsql

eehab hamzeh eehab40 at hotmail.com
Fri Feb 20 13:33:50 PST 2009


Thanks for your replay

i need to check if the resultof this query is null or not null then do two different things

 as below 

if  SELECT DISTINCT o FROM ramadan  WHERE o=mypoint or a=mypoint 
UNION SELECT DISTINCT a FROM ramadan WHERE o=mypoint or a=mypoint;
 

is null then 


 

 

INSERT INTO eehab (field1) -- replace with whatever your field name is
SELECT DISTINCT o 
FROM ramadan 
WHERE o=mypoint or
a=mypoint 
UNION SELECT DISTINCT a 
FROM ramadan 
WHERE o=mypoint or a=mypoint;


 

else 

do some thing else

 

 

can u please give me diretion to do so. i have limmited time to develop this function

 

kind regards

 

_________________________________________________________________
More than messages–check out the rest of the Windows Live™.
http://www.microsoft.com/windows/windowslive/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090220/c2bc46dd/attachment.html>


More information about the postgis-users mailing list