| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Marie G(dot) Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com> |
| Cc: | "Pgsql-Sql(at)Postgresql(dot) Org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: record count |
| Date: | 2002-08-29 19:06:26 |
| Message-ID: | 20020829190626.GB25628@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Aug 29, 2002 at 13:37:40 -0500,
"Marie G. Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com> wrote:
>
> Is there a system attribute or table or ? providing record count by table?
No. Normally you use the count aggregate to obtain that information.
However if you do few updates and need this information fairly often,
then you may want to keep the data in your own table using triggers.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zenith Vivas | 2002-08-29 19:20:46 | How to Select with more than one AND in a Where SQL Clause? |
| Previous Message | Josh Berkus | 2002-08-29 18:59:08 | Re: How to Select with more than one AND in a Where SQL Clause? |