[GENERAL] Using PL/pgSQL

I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm using PostGres 6.5.x (I know I need to upgrade...but that is another subject...). So far I've done the following: create function pgpgsql_call_handler() returns opaque as '/usr/local/pgsql/lib/plpgsql.so' language 'C'; create

[GENERAL] SQL Join for a Calculation

Here's a description of the scenario. The question I'm asking follows the description. 3 tables table1: job_no int4 rate1 float4 qty1 float4 rate2 float4 qty2 float4 rate3 float4 qty3 float4 table2: job_no int4 part_id int4 rate float4 qty float4 table3: job_no int4 desc varchar(32) rate float4