Search Postgresql Archives

Re: How to optimize SELECT query with multiple CASE statements?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to optimize SELECT query with multiple CASE statements?
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Mon, 31 Oct 2016 18:15:26 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAEzk6fdkjKATL14KPx3E3q6wYoTvUz-Lew0T0atTjvDqnaqbXg@mail.gmail.com>
References: <CAADeyWg1fezpVYPfvqM678bfJgp=5+t0VuR-MTbmRWAo-ndV_w@mail.gmail.com> <CAEzk6fdjR+an1H=9xzDXKHeXXmge7uLbg8Hi3+wZQpi0_iCb2w@mail.gmail.com> <CAADeyWjnHtbpajxy6wcfJt2-3yifF2JmZcShvJg5ucZmktUF_w@mail.gmail.com> <CAEzk6fdkjKATL14KPx3E3q6wYoTvUz-Lew0T0atTjvDqnaqbXg@mail.gmail.com>

Ah, thanks - I've got that with JOINing via CASE now...

On Mon, Oct 31, 2016 at 5:50 PM, Geoff Winkless <pgsqladmin@xxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- How to optimize SELECT query with multiple CASE statements?
  - From: Alexander Farber
- Re: How to optimize SELECT query with multiple CASE statements?
  - From: Geoff Winkless
- Re: How to optimize SELECT query with multiple CASE statements?
  - From: Alexander Farber
- Re: How to optimize SELECT query with multiple CASE statements?
  - From: Geoff Winkless

Prev by Date: Re: Rows are repeating by the trigger function
Next by Date: Re: initdb createuser commands
Previous by thread: Re: How to optimize SELECT query with multiple CASE statements?
Next by thread: Re: How to optimize SELECT query with multiple CASE statements?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]