[postgis-users] writing loop and conditionals in pl/pgsql

[Rémi Cura]

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 <many_yammy at yahoo.com>:

> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140305/fb50547f/attachment.html>