Is this a neat idea?

SELECT * FROM (SHOW ALL);

eg.

SELECT * FROM tab WHERE character_length(f) > (SHOW block_size);

etc.

Chris


Fri, 16 Jan 2004 10:13:54 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Make SHOW command subqueriable?


On Fri, 16 Jan 2004, Christopher Kings-Lynne wrote:

> Is this a neat idea?
>
> SELECT * FROM (SHOW ALL);

So neat in fact that it has been implemented.

SELECT * FROM pg_settings;

Kris Jurka



Thu, 15 Jan 2004 21:22:26 -0500 (EST)
Kris Jurka <books@ejurka.com>
Re: Make SHOW command subqueriable?
> So neat in fact that it has been implemented.
> 
> SELECT * FROM pg_settings;

Damn! I knew that as well!  *sigh*

I'm not thinking right from my current 'shocking postgres performance 
problems nightmare day' today :(

Think massively concurrent table that almost everything on the site 
relates to causing heaps of select queries to pile up and use all I/O, 
getting worse, etc...

Chris


Fri, 16 Jan 2004 10:37:17 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Make SHOW command subqueriable?