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
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 :
> Hi all,
> I am quite new to pl/pgsql and completely confused.
> I have
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of mane moshref
Sent: Wednesday, March 05, 2014 10:38 AM
To: postgis-users@lists.osgeo.org
Subject: [postgis-users] writing loop and conditionals in pl/pgsql
Hi all,
I am quite new to pl/pgs
Thanks guys.
But first of all I have to do this with pl/pgsql. This is not the matter of
having answer in my db. It is the matter of solving problem with pl/pgsql.
Rémi-C thank you for the link. I already went through it but it just explain
very basic structure. I couldn't find my answers the