For example:
set search_path = scratch;
drop materialized view if exists temp_a;
create materialized view temp_a as
select version() as str;
create index on temp_a (str);
select *
from temp_a;
Data Output:
str text
PostgreSQL 9.3.9 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4
Thanks - the patch looks OK to my eyeballs. Ashesh said he'd take a
look as well, and (I hope) will get it committed. :-)
On Tue, Sep 8, 2015 at 8:34 AM, Sanket Mehta
wrote:
> Hi Dave,
>
> I have created and attached the patch which will set 0 in case of any
> negative coordinate for any window.