Re: Grouping My query - Mailing list pgsql-general

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 code, I wish one day it can
be achieved with a SQL Statament thanks again .

Kind Regards.
+-----------------------------------------------------+
| Martin W. Kuria (Mr.) martin.kuria@unon.org
+----------------------------------------------------+



>From: Richard Huxton <dev@archonet.com>
>To: Martin Kuria <martinkuria@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Grouping My query
>Date: Wed, 01 Nov 2006 18:50:46 +0000
>
>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 achieve the output below please do
>>assist. As you can see the staff members are group in their respective
>>Categories and Subcategory unlike the output above.
>>
>>staff_lname | staff_fname | staff_id | staff_catid | staff_subcatid |
>>cat_acron | subcat_acron | staff_sortorder
>>-------------+-------------+----------+-------------+----------------+-----------+--------------+-----------------
>>
>>ADSDS
>>ODA
>>  Vacant      | Vacant      |     8836 |         500 |            534 |
>>ADSDS      | ODA         |               0
>>  nnnnn       | aaaaa       |     7148 |         500 |            534 |
>>ADSDS      | ODA         |               0
>>WEB
>>  bbbbb       | Sbbbbb      |     7150 |         500 |            534 |
>>ADSDS      | WEB         |               1
>>  xxxxx       | cccccc      |     7174 |         500 |            534 |
>>ADSDS      | WEB         |               1
>>  eeeee       | dddddd      |     7173 |         500 |            534 |
>>ADSDS      | WEB         |               2
>
>Am I right in thinking you're trying to do headings here?
>   heading1: ADSDS
>   heading2: ODA
>   ...rows...
>   heading2: WEB
>   ...rows...
>
>This is a formatting issue - do it in your client code. There are report
>-generating systems available for many languages.
>
>--
>   Richard Huxton
>   Archonet Ltd

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/