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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Count


  • From: Bob Pawley <rjpawley(at)shaw(dot)ca>
  • To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
  • Subject: Count
  • Date: Wed, 23 Jan 2008 10:50:48 -0800
  • Message-id: <010601c85df0$de87b8f0$6401a8c0(at)owner>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group