Re: sum(if command - Mailing list pgsql-general

From Jochem van Dieten
Subject Re: sum(if command
Date
Msg-id 1032182652.3d85db7c8d52b@webmail.oli.tudelft.nl
Whole thread Raw
In response to sum(if command  ("king" <king_pepper99@hotmail.com>)
List pgsql-general
Quoting king <king_pepper99@hotmail.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

pgsql-general by date:

Previous
From: "Roy P. Ammeraal"
Date:
Subject: Error compiling tab-complete
Next
From: Tom Lane
Date:
Subject: Re: C-language example of using/returning numeric