It sounds like the caller is simply trying to see if the engine is up
and operational.
If that is the case, then just connect, disconnect.
Jonathan Bartlett wrote:
>Might select NULL; be faster, since the number doesn't have to be parsed,
>and null is probably a keyword?
>
>Jon
>
>On Thu, 20 Feb 2003, Tino Wildenhain wrote:
>
>
>
>>Hi P G,
>>
>>On Thu, 20 Feb 2003 09:52:07 -0800 (PST)
>>P G <pg_dba@yahoo.com> wrote:
>>
>>
>>
>>>What is the quickest and least intrusive query in the
>>>database that will always succeed?
>>>
>>>
>>select 1;
>>
>>:o)
>>
>>Regards
>>Tino
>>
>>
>>
>>
>>>select current_user;
>>>
>>>-- OR --
>>>
>>>select datname from pg_database where datname =
>>>'some_database';
>>>
>>>Or would it be something else?
>>>
>>>TIA.
>>>
>>>__________________________________________________
>>>Do you Yahoo!?
>>>Yahoo! Tax Center - forms, calculators, tips, more
>>>http://taxes.yahoo.com/
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>>subscribe-nomail command to majordomo@postgresql.org so that your
>>>message can get through to the mailing list cleanly
>>>
>>>
>>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/users-lounge/docs/faq.html
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>