work on rows - Mailing list pgsql-sql

From Rachel Coin
Subject work on rows
Date
Msg-id 00b701c0a739$c8170460$6101a8c0@spidinfo.com
Whole thread Raw
Responses Re: work on rows  (dev@archonet.com)
List pgsql-sql
Hello,
 
I have a problem with a sql query.I have two tables : the first contains categories and the second subcategories.
 
What kind of select may I use to get something like Yahoo! categories ( each "main" category gets *at most* three sub-categories..
 
Thanks
Regards,
 
Rachel
 
 
 
 

pgsql-sql by date:

Previous
From: Xu Yifeng
Date:
Subject: Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?
Next
From: Roland Roberts
Date:
Subject: Re: Permissons on database