Skip site navigation (1) Skip section navigation (2)

Re: Question

From: Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>
To: Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Question
Date: 2004-02-21 16:10:30
Message-ID: 403782F6.5050404@frodo.hserus.net (view raw or flat)
Thread:
Lists: pgsql-advocacy
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.

  Shridhar

In response to

Responses

pgsql-advocacy by date

Next:From: David CostaDate: 2004-02-21 16:16:09
Subject: Re: Question
Previous:From: Magnus HaganderDate: 2004-02-21 16:07:05
Subject: Re: News Feed: PHP/Postgresql Advocacy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group