[HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Christopher Kings-Lynne
Is this a neat idea? SELECT * FROM (SHOW ALL); eg. SELECT * FROM tab WHERE character_length(f) (SHOW block_size); etc. Chris ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining

Re: [HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Kris Jurka
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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the

Re: [HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Christopher Kings-Lynne
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