Skip site navigation (1) Skip section navigation (2)

Re: Table-design for categories, suggestions needed

From: Rikard Bosnjakovic <rikard(dot)bosnjakovic(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Table-design for categories, suggestions needed
Date: 2010-08-05 01:32:30
Message-ID: AANLkTimGzX2yKugT_RFd8eVtFpqNnSz5yfucGs6R5fzQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Richard BroersmaDate: 2010-08-05 14:38:32
Subject: Re: Table-design for categories, suggestions needed
Previous:From: Rikard BosnjakovicDate: 2010-08-05 01:30:42
Subject: Table-design for categories, suggestions needed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group