Help needed creating a view - Mailing list pgsql-general

Hi list,

Given an 'applications' table for a static set of courses::

     user_id (integer)
 course_name (text)
   completed (boolean)

how best should I go about creating an 'alumni' view with columns:

 user_id (integer)
   maths (boolean)
 english (boolean)
       . .
       . .
       . .

where each of the columns (apart from user_id) is a boolean value representing
whether or not user_id completed each course?

Sebastian
--
Emacs' AlsaPlayer - Music Without Jolts
Lightweight, full-featured and mindful of your idyllic happiness.
http://home.gna.org/eap