Re: DUPS in tables columns ERROR: column ". . . " does not exist - Mailing list pgsql-general

From Tom Lane
Subject Re: DUPS in tables columns ERROR: column ". . . " does not exist
Date
Msg-id 29802.1220115901@sss.pgh.pa.us
Whole thread Raw
In response to Re: DUPS in tables columns ERROR: column ". . . " does not exist  ("Albretch Mueller" <lbrtchx@gmail.com>)
Responses Re: DUPS in tables columns ERROR: column ". . . " does not exist  ("Albretch Mueller" <lbrtchx@gmail.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Albretch Mueller"
Date:
Subject: Re: DUPS in tables columns ERROR: column ". . . " does not exist
Next
From: "Matthew Dennis"
Date:
Subject: Re: indexes on functions and create or replace function