Re: [HACKERS] Index expression syntax

2017-09-29 Thread Konstantin Knizhnik
On 29.09.2017 11:03, Marko Tiikkaja wrote: On Fri, Sep 29, 2017 at 9:31 AM, Konstantin Knizhnik > wrote: I wonder why syntax error is produced in this case: postgres=# create index metaindex on foo using

Re: [HACKERS] Index expression syntax

2017-09-29 Thread Marko Tiikkaja
On Fri, Sep 29, 2017 at 9:31 AM, Konstantin Knizhnik < k.knizh...@postgrespro.ru> wrote: > I wonder why syntax error is produced in this case: > > postgres=# create index metaindex on foo using gin(to_tsvector('english', > x)||to_tsvector('english',y)); > ERROR: syntax error at or near "||" >

[HACKERS] Index expression syntax

2017-09-29 Thread Konstantin Knizhnik
I wonder why syntax error is produced in this case: postgres=# create index metaindex on foo using gin(to_tsvector('english', x)||to_tsvector('english',y)); ERROR: syntax error at or near "||" LINE 1: ...taindex on foo using gin(to_tsvector('english', x)||to_tsvec...