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 many_ya...@yahoo.com:
Hi all,
I am quite new to pl/pgsql and completely
select
*
from
tab1, tab2
Where
tab1.hk_id = tab2.hk_id -- Assuming you have a ID column in
both tables . . .
AND
tab2.y_max tab1.h_max
AND
tab2.y_max tab1.h_min
order by
tab2.height
Bobb
From:
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