Categories and subcategories

From: "Rachel Coin" <rachel(at)derniere-minute(dot)org>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Categories and subcategories
Date: 2001-03-20 08:48:21
Message-ID: 002601c0b11a$8e1e7280$6101a8c0@spidinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have two tables : the first for categories and the second for
subcategories.I want to get a result like Yahoo! For each category , the sql
query must return maximum 3 subcategories. I can't use "limit" in a subquery
because I use Postgresql 7.0.

Any help?

Regards,

Rachel

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Kirkwood 2001-03-20 08:59:58 Re: Select very slow
Previous Message Josh Berkus 2001-03-20 04:46:39 Re: count() and multiple tables