On Thu, Aug 5, 2010 at 03:30, Rikard Bosnjakovic
<rikard(dot)bosnjakovic(at)gmail(dot)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