Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15475: Views over CITEXT columns return no data - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: BUG #15475: Views over CITEXT columns return no data
Date
Msg-id CAEepm=22YYxv_7EF3GH2gv55ZYFXMuacqAhqvGEOm=zywYOmuw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15475: Views over CITEXT columns return no data  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-bugs
Tree view 
On Fri, Nov 2, 2018 at 3:00 PM Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> ...  The effect of that
> thinko is to make them behave like inner joins (but only in multi-batch
> joins, ie when work_mem is exceeded).

To be more precise, I meant they behave like inner joins just for rows
with NULL keys, not in general.

-- 
Thomas Munro
http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition
Next
From: Paul van der Linden
Date:
Subject: RE: BUG #15460: Error while creating index or constraint