Postgres Pro
Downloads
Home   >   mailing lists

Categories and subcategories - Mailing list pgsql-sql

From Rachel Coin
Subject Categories and subcategories
Date
Msg-id 002601c0b11a$8e1e7280$6101a8c0@spidinfo.com
Whole thread Raw
Responses Re: Categories and subcategories  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: serial type question
Next
From: Mark Kirkwood
Date:
Subject: Re: Select very slow