From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Martin Kuria <martinkuria(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Grouping My query |
Date: | 2006-11-01 18:50:46 |
Message-ID: | 4548EC86.7010704@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ritesh Nadhani | 2006-11-01 18:52:16 | Re: Updated: Compiling/Installing as a non-admin user |
Previous Message | Thomas Kellerer | 2006-11-01 18:15:28 | Re: Compiling/Installing as a non-admin user |