Re: Limits of SQL

From: Joachim Zobel <jzobel(at)heute-morgen(dot)de>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Limits of SQL
Date: 2005-06-05 18:53:30
Message-ID: 1117997610.4455.14.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Samstag, den 04.06.2005, 15:22 -0500 schrieb Bruno Wolff III:
> On Sat, Jun 04, 2005 at 21:53:24 +0200,
> Joachim Zobel <jzobel(at)heute-morgen(dot)de> wrote:
> > So WITH will allow recursion so I can walk the graph, right? Does this
> > mean I can recursively join until a terminating condition is reached?
>
> It can be used to compute transitive closures, which I think is what
> you are really looking for.

There aren't any plans to implement grouping by a user defined
equivalence relation? This is the other thing I am missing. But OK, WITH
will keep me happy for some time :)

Sincerely,
Joachim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Seltenreich 2005-06-05 21:35:05 Re: Limits of SQL
Previous Message Zlatko Matić 2005-06-05 10:53:08 logout Postgres from MS Access (ODBC) ?