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/
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to