Re: Sort is generating rows

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Nicolas Seinlet <nicolas(at)seinlet(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Sort is generating rows
Date: 2018-06-11 17:00:05
Message-ID: bc63257b-5062-6e2d-a91c-c4ae1ada83f8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/10/2018 11:47 PM, Nicolas Seinlet wrote:
> Hi,
>
> a currency rate can have no company, and is then applicable to
> currencies which have no rate specific for the company.
>

I see. So what happens if, for testing purposes, you eliminate the

r.company_id IS NULL OR

part?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-06-11 17:03:44 Re: pg_upgrade and wraparound
Previous Message Adrian Klaver 2018-06-11 16:56:19 Re: Fwd: Add to watchdog cluster request is rejected by node