Re: Table-design for categories, suggestions needed - Mailing list pgsql-novice

On Thu, Aug 5, 2010 at 03:30, Rikard Bosnjakovic
<rikard.bosnjakovic@gmail.com> wrote:

> Real example: Top-category "IC", subcat1 "Logic", subcat2 "TTL":

A more readable output:

# select id, name, subcategory_1, subcategory_2 from categories where id > 3;
 id | name  | subcategory_1 | subcategory_2
----+-------+---------------+---------------
  4 | IC    |               |
  6 | Logic |             4 |
 10 | CMOS  |               |             6
 11 | TTL   |               |             6


--
- Rikard