Re: [GENERAL] endash not a graphic character?

Hello Bruno, On Sat, 2016-08-20 at 14:04 -0500, Bruno Wolff III wrote: > I was surprised to find endash and emdash were not graphic characters > in  > en_US. I'm not sure if this is correct behavior, a bug in postgres or > a  > bug in my OS' collation definitions? > > For example: > > Dash: >

Re: [GENERAL] Critical failure of standby

On Mon, Aug 15, 2016 at 7:23 PM, James Sewell wrote: > Those are all good questions. > > Essentially this is a situation where DR is network separated from Prod - > so I would expect the archive command to fail. > archive_command or restore_command? I thought it was

[GENERAL] endash not a graphic character?

I was surprised to find endash and emdash were not graphic characters in en_US. I'm not sure if this is correct behavior, a bug in postgres or a bug in my OS' collation definitions? For example: Dash: area=> select '-' ~ '[[:graph:]]' collate "en_US"; ?column? -- t (1 row) Endash:

Re: [GENERAL] Limit Heap Fetches / Rows Removed by Filter in Index Scans

Victor: On Fri, Aug 19, 2016 at 8:01 PM, Victor Blomqvist wrote: > Thanks! A sub select seems to do it. I suspected it would be needed, that's why I sugested it. I prefer to write the queries as CTEs because they are much easier to read, but IIRC they are some kind of