[GENERAL] Store derived data or use view?

2009-07-03 Thread gvimrc
I have a table which stores the absolute longitude of a planetary position, eg: MERCURY --- 157.65 SATURN - 247.65 When 2 planets are a certain distance apart there is an 'aspect', eg. 90 degrees is a "square" aspect I wish to record these aspects for different user pr

[GENERAL] pl/sql resources for pl/pgsql?

2009-06-15 Thread gvimrc
I'm fairly new to PostgreSQL and completely new to using pl/pgsql though I've used MySQL's procedural language a little. I heard pl/pgsql is similar to Oracle's pl/sql so would it be possible, given that pl/pgsql literature is a bit thin on the ground, to use books on pl/sql for developing pl/p