Postgres Pro
Downloads
Home   >   mailing lists

Re: Counting boolean values (how many true, how many false) - Mailing list pgsql-general

From Marc Mamin
Subject Re: Counting boolean values (how many true, how many false)
Date
Msg-id C4DAC901169B624F933534A26ED7DF31034BB907@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: Counting boolean values (how many true, how many false)  (André Fernandes<andre.de.camargo.fernandes@hotmail.com>)
List pgsql-general
Tree view 
sum(case when fair then 1 else 0 end) as fair,
=>
sum(case when fair then 1 end) as fair,

:)

regards,

Marc Mamin

pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Next
From: Dimitri Fontaine
Date:
Subject: Re: Can you check in SQL if a fields can be encoded using specified charset