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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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