Re: sum(if command

From: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>
To: king <king_pepper99(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sum(if command
Date: 2002-09-16 13:24:12
Message-ID: 1032182652.3d85db7c8d52b@webmail.oli.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Quoting king <king_pepper99(at)hotmail(dot)com>:
>
> Does posgres support the equivalent to the mysql sum(if command in a
> SQL statement? I did not see reference to it in my readings.

The SQL standard CASE statement is supported and it can do the same.

Jochem

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2002-09-16 13:34:20 problems to restore database with custom datatypes (e.g. txtidx)
Previous Message Tom Lane 2002-09-16 13:15:36 Re: C-language example of using/returning numeric