Use for loop in stored procedure to join query results

Hello,

I have a table similar to the following:

id   probe   value
1   asdf   10
1   qwer   20
1   zxcv   30
2   asdf   40
2   qwer   50
2   zxcv   60

I would like to create a stored procedure or function that will make a view
with the data as follows:

           1     2
asdf    10   40
qwer   20   50
zxcv   30   60

Does anyone know how to do this?  I am attempting to make a stored procedure
that...
1. SELECT all distinct "id"s
2. FOR LOOP to iterate over each "id", SELECT probe, value  WHERE
id=
3. JOIN resulting table to table from previous iteration of the FOR loop

Unfortunately, I am not sure if this is a good way to do this.  And I am not
familiar with stored procedure syntax.  Can anyone help with this?

Thanks,
RC


-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/Use-for-loop-in-stored-procedure-to-join-query-results-tp3286416p3286416.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.