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

Re: count(1) return 0?

From: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
To: Zak McGregor <zak(at)mighty(dot)co(dot)za>,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:33:11
Message-ID: 200402291733.11848.uwe@oss4u.com (view raw or flat)
Thread:
Lists: pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


What is it you want ? the count of rows matching the criteria ?
If so a standard count(*) should do. If the resultset has no rows the count(*) 
will return 0 as result.


On Sunday 29 February 2004 05:02 pm, Zak McGregor wrote:
> 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
> ========================================================================
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

- -- 
	UC

- --
Open Source Solutions 4U, LLC	2570 Fleetwood Drive
Phone:  +1 650 872 2425		San Bruno, CA 94066
Cell:   +1 650 302 2405		United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAQpLXjqGXBvRToM4RAh1CAJ4knBgzklnG+Dmuy+62LNAU3JGqDwCcCxUY
w1VAIOauzfpO49QgK42et4c=
=/U+x
-----END PGP SIGNATURE-----


In response to

pgsql-general by date

Next:From: John WellsDate: 2004-03-01 01:37:52
Subject: A simple question (under pressure :-))....
Previous:From: Zak McGregorDate: 2004-03-01 01:27:39
Subject: Re: count(1) return 0?

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