| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | ps(at)ipggroup(dot)com, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15475: Views over CITEXT columns return no data |
| Date: | 2018-11-02 03:07:21 |
| Message-ID: | CAEepm=22YYxv_7EF3GH2gv55ZYFXMuacqAhqvGEOm=zywYOmuw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Nov 2, 2018 at 3:00 PM Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul van der Linden | 2018-11-02 08:02:26 | RE: BUG #15460: Error while creating index or constraint |
| Previous Message | Amit Langote | 2018-11-02 02:45:29 | Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition |