Thread: Make SHOW command subqueriable?

Is this a neat idea?

SELECT * FROM (SHOW ALL);

eg.

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

etc.

Chris

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

> 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