Postgres Pro
Downloads
Home   >   mailing lists

Re: How to optimize SELECT query with multiple CASE statements? - Mailing list pgsql-general

From Alexander Farber
Subject Re: How to optimize SELECT query with multiple CASE statements?
Date
Msg-id CAADeyWjDeeDij2K0fWGsJBu2_eFbUjA3W93-UbzrEZBkf59SzA@mail.gmail.com
Whole thread Raw
In response to Re: How to optimize SELECT query with multiple CASE statements?  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
Tree view
Ah, thanks - I've got that with JOINing via CASE now...

On Mon, Oct 31, 2016 at 5:50 PM, Geoff Winkless <pgsqladmin@geoff.dj> wrote:
especially since (as I said in the last paragraph of my email), you
can remove all of the CASEs except the hand/score ones by just JOINing
the other tables via a CASE anyway.

pgsql-general by date:

Previous
From: Kiran
Date:
Subject: Re: Rows are repeating by the trigger function
Next
From: "Daniel Verite"
Date:
Subject: Re: initdb createuser commands