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: > area=> select '-' ~ '[[:graph:]]' collate "en_US"; > ?column? > ---------- > t > (1 row) > > Endash: > area=> select '–' ~ '[[:graph:]]' collate "en_US"; > ?column? > ---------- > f > (1 row) > > > Emdash: > area=> select '—' ~ '[[:graph:]]' collate "en_US"; > ?column? > ---------- > f > (1 row) > >
You can't use — (emdash) or – (endash)? Or their hex equivalents. See the Unicode chart. HTH, rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
