http://www.postgresql.org/docs/9.3/static/plpgsql.html
I'm not sure you need plpgsql for this, looks like you could do in sql only (maybe even no need of CASE WHEN) Cheers, Rémi-C 2014-03-05 17:38 GMT+01:00 mane moshref <[email protected]>: > Hi all, > I am quite new to pl/pgsql and completely confused. > I have two tables. One storing height category including hk_id(height > category id), h_min and h_max. and a table including several plygons having > y_max and height. My aim is to know on which height category the plygon > locates based on its y_max. > My piece of code is like: > i=1; a=0; > while (i=<4 , a=0){ > if h(i)_min < y_max < h(i)_max > {height = i > a = 1;} > i = i + 1 > } > Is there any body who can help me to convert this piece of code to > excutable format in pl/pgsql? > Thank you in advance > Many > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
