Saturday, August 30, 2008

Re: [GENERAL] DUPS in tables columns ERROR: column ". . . " does not exist

"Albretch Mueller" <lbrtchx@gmail.com> writes:
> thank you Stefan your SQL worked, but still; I am just asking and my
> programming bias will certainly show, but aren't you effectivly
> "calling" count on the table three times if you go:

The system is smart enough to only do the count() once.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: