Skip site navigation (1) Skip section navigation (2)

Re: count(1) return 0?

From: Zak McGregor <zak(at)mighty(dot)co(dot)za>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: count(1) return 0?
Date: 2004-03-01 01:02:29
Message-ID: 20040301030229.5bbf6565.zak@mighty.co.za (view raw or flat)
Thread:
Lists: pgsql-general
On Sun, 29 Feb 2004 19:55:15 -0500
Bill Moran <wmoran(at)potentialtech(dot)com> wrote:

> Not really sure I understand what you want, but try something like this:
> 
> select case when count(*) > 0 then ''t'' else ''f'' end from ...

Unfortunately that does not work. When the resultset contains no records
whatsoever, I get no rows at all - so on case...else sort of expression within
the select itself will work.

What I am looking for is a way to select "0" if no rows are returned, or the
total number of rows returned from the query otherwise.

Thanks anyways though.

Ciao

Zak

--
========================================================================
http://www.carfolio.com/        Searchable database of 10 000+ car specs
========================================================================

In response to

Responses

pgsql-general by date

Next:From: Bill MoranDate: 2004-03-01 01:02:40
Subject: Re: count(1) return 0?
Previous:From: Bill MoranDate: 2004-03-01 00:55:15
Subject: Re: count(1) return 0?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group