From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2005-01-02 10:49:18
Message-ID: A3D1526C98B7C1409A687E0943EAC41001EB1E@obelix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Is it possible to count and display the number of children of a parent in a generic query?

parent table: id
child table: id, parent_id

Example output of the query:

parentid number_of_children
parent1 2
parent2 6
parent3 0

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

  • Re: at 2005-01-02 17:22:44 from John Sidney-Woollett

Browse pgsql-general by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2005-01-02 11:04:27 Re: many similar indexbased selects are extremely slow
Previous Message Vincent Hikida 2005-01-02 09:59:34 Re: Question on a select