From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: pgsql-sql@postgresql.org
Subject: select from table and add rows.
Date: Fri, 6 Jul 2007 14:25:08 +0100
User-Agent: KMail/1.9.5
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200707061425.09074.gary.stainburn@ringways.co.uk>

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