[SQL] select from table and add rows.

[Gary Stainburn]

Hi folks.

In PHP I often do things such as:

$wpartners=array('all'=>'All','sel'=>'Current','mine'=>'Mine');
 foreach(
     loadhash("select p_id as key, p_name as value 
                      from partners order by p_name"
                  ) 
      as $key=>$dets) {
  $wpartners[$key]=$dets;
}

This sets up an array with some pseudo values and then populates it with 
*proper* values from a table.

How's the best way to do this all within SQL. 
-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org