Rod Taylor wrote:
> rbt=# select nspname, sum(relpages) from pg_class join pg_namespace n on
> (relnamespace = n.oid) group by nspname, relnamespace having 2 > (SELECT
> count(*) from pg_constraint where relnamespace = connamespace);
> With some effort you might be able to get the above down to a single
> line (shorter column names, etc.).
> It takes the sum of pages used by relations in namespaces with a minimum
> of 2 constraints.
I think any query fiddling with metadata is a bad idea for a sig.
I would say overriding function calls in a single query would make great
example. After all O in ORDBMS is for overriding..:-)
How about declaring a contest on general? An event always stirrs up creativity.
In response to
pgsql-advocacy by date
|Next:||From: David Costa||Date: 2004-02-21 16:16:09|
|Subject: Re: Question|
|Previous:||From: Magnus Hagander||Date: 2004-02-21 16:07:05|
|Subject: Re: News Feed: PHP/Postgresql Advocacy|