Replica string comparsion issue

2018-06-13 Thread Andrey Lizenko
Hello, I'm observing strange behaviour on comparing ::text field with string while quering replica. Here is the table structure: =# \dS+ raw.symbols_aggregates > Table > "raw.symbols_aggregates" >Column | Type | Collation |

Re: Replica string comparsion issue

2018-06-13 Thread Andrey Lizenko
> limit 5; > date_started |symbol > --+-- > 1970-01-01 | /EPRH18:XMON > 1970-01-01 | /EPRM18:XMON > 1970-01-01 | /FCEF18:XMON > 1970-01-01 | /FCEG18:XMON > 1970-01-01 | /FCEH18:XMON On Wed, Jun 13, 2018 at 10:38 PM Tom Lane wrote: &g