On Fri, Oct 08, 2004 at 11:21:25PM +0530, sreejith s wrote:
> How to get a the records returned by a sql executed within a pl/pgsql function
It's not clear what you're asking, but perhaps one of the following
pages will answer your question:
http://www.postgresql.org/docs/7.4/static/plpgsql-stat
Friends,
How to get a the records returned by a sql executed within a pl/pgsql function
Sreejith
---(end of broadcast)---
TIP 8: explain analyze is your friend
>
> Hello list,
>
> Is there a system attribute or table or ? providing record count by table?
>
> Thanks.
>
pg_class.reltuples has the record count.
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
On Thu, Aug 29, 2002 at 13:37:40 -0500,
"Marie G. Tuite" <[EMAIL PROTECTED]> 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 fairl
Hello list,
Is there a system attribute or table or ? providing record count by table?
Thanks.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
