Re: query or schema question

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Scott Frankel <leknarf(at)pacbell(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: query or schema question
Date: 2004-12-15 05:07:19
Message-ID: 20041215050718.GA29141@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 14, 2004 at 07:23:31PM -0800, Scott Frankel wrote:

> is there a reasonable way to traverse the dependencies from the
> students table back to the universities table?

See the documentation for joined tables in the Tutorial and in the
SQL Language documentation. It sounds like you want to join the
students table to departments, and departments to universities.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2004-12-15 05:11:35 Re: Corrupt RTREE index
Previous Message Greg Stark 2004-12-15 04:48:33 Re: Corrupt RTREE index