Re: What is the quickest query in the database?

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
>