Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Query and the number of row result
- From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: Query and the number of row result
- Date: Mon, 31 Aug 2009 17:00:27 +0000
- Message-id: <m38wgz7wb8.fsf@passepartout.tim-landscheidt.de> <text/plain>
bilal ghayyad <bilmar_gh(at)yahoo(dot)com> wrote: > I am talking in case I am writing a script for a function, > and I need to know the number of the returned rows of the > query, then I will do IF statement based on that number, > how? > [...] Presuming that you are talking about a function written in PL/pgSQL, you will have to count them yourself or issue a second query "SELECT COUNT(*) FROM [...]". For the special case that you want to find out whether no row at all was found, you can look at "IF (NOT) FOUND". Tim
- References:
- Re: Query and the number of row result
- From: Naoko Reeves
- Re: Query and the number of row result
- From: bilal ghayyad
- Re: Query and the number of row result
- Prev by Date: Re: indexes on partitioned tables - on the base table, or the partitioned tables?
- Next by Date: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
- Previous by thread: Re: Query and the number of row result
- Next by thread: Re: Query and the number of row result
- Indexes: