Count

From: Bob Pawley <rjpawley(at)shaw(dot)ca>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Count
Date: 2008-01-23 18:50:48
Message-ID: 010601c85df0$de87b8f0$6401a8c0@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with four columns that will either be null or hold the value
'true'.

I want to obtain the count of these columns, within a particular row, that
have 'true' as a value (0 to 4).

I have attempted the Select count method but it seems that I need something
more.

If anyone has any thoughts it would be much appreciated.

Bob

Responses

  • Re: Count at 2008-01-23 19:22:37 from Bricklen Anderson
  • Re: Count at 2008-01-23 19:54:52 from Jeff Davis
  • Re: Count at 2008-01-23 19:59:22 from brian
  • Re: Count at 2008-01-23 20:08:09 from Charles Simard

Browse pgsql-general by date

  From Date Subject
Next Message Rick Schumeyer 2008-01-23 19:10:09 Re: Tips for upgrading from 7.4
Previous Message Luis Alberto Pérez Paz 2008-01-23 18:46:19 Re: Postgresql + digital signature