Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Query and the number of row result
- From: Adrian Klaver <aklaver(at)comcast(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Cc: bilal ghayyad <bilmar_gh(at)yahoo(dot)com>, David Fetter <david(at)fetter(dot)org>
- Subject: Re: Query and the number of row result
- Date: Mon, 31 Aug 2009 07:34:15 -0700
- Message-id: <200908310734.16016.aklaver@comcast.net> <text/plain>
On Monday 31 August 2009 4:10:48 am bilal ghayyad wrote: > Just writing a Function in the PostgreSQL it self (so it is sql scripting). > It is not from any development language. > > Regards > Bilal > If you move to pl/pgsql you could use GET DIAGNOSTICS: (http://www.postgresql.org/docs/8.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS) It has ROW_COUNT. -- Adrian Klaver aklaver(at)comcast(dot)net
- References:
- Re: Query and the number of row result
- From: bilal ghayyad
- Re: Query and the number of row result
- Prev by Date: Re: Query and the number of row result
- Next by Date: print/return only the first X chars of a varchar column?
- Previous by thread: Re: Query and the number of row result
- Next by thread: indexes on partitioned tables - on the base table, or the partitioned tables?
- Indexes: