Re: [GENERAL] Grouping My query

2006-11-02 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/01/06 23:43, Martin Kuria wrote: > Dear Richard, > > Thanks for your response, you are right I am trying to do headings, I > thought I could do it from writing a SQL statement, but as you have > suggested it can only be achieved on the client co

Re: [GENERAL] Grouping My query

2006-11-01 Thread Martin Kuria
. +-+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED] ++ From: Richard Huxton To: Martin Kuria <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Grouping My query Dat

Re: [GENERAL] Grouping My query

2006-11-01 Thread Richard Huxton
Martin Kuria wrote: Dear Sir/Madam, I have a staff directory, which group staff in various categories I would like to group the staff members in there specific categories, Below is an output I would like to achieve can this be achived my using the Group by or I can write a script to achiev

[GENERAL] Grouping My query

2006-11-01 Thread Martin Kuria
Dear Sir/Madam, I have a staff directory, which group staff in various categories I would like to group the staff members in there specific categories, Below is query is query I am running, it works fine and returns the output below. My question is, how do I Group the staff members in there r