From: | David Costa <geeks(at)dotgeek(dot)org> |
---|---|
To: | Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net> |
Cc: | Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: Question |
Date: | 2004-02-21 16:16:09 |
Message-ID: | 42799097-6489-11D8-A344-000A95EB456A@dotgeek.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
Anyone with something simple like SELECT from bestdatabases where
logic_power.....opensource....
something not that complicate.
Imagine we have a table with a number of relational databases listed.
And our query will return postgresql :D
On Feb 21, 2004, at 5:10 PM, Shridhar Daithankar wrote:
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2004-02-21 16:37:58 | Re: Question |
Previous Message | Shridhar Daithankar | 2004-02-21 16:10:30 | Re: Question |