"Andy Hallam" <ahm(at)exel(dot)co(dot)uk> writes:
> SELECT a FROM b WHERE c = 'WORKGROUP\me'
> Does not return any rows.
> SELECT a FROM b WHERE c = 'WORKGROUP\\me'
> Returns required rows.
> Can someone confirm this to be a bug please.
This is not a bug. Backslash is an escape character in Postgres'
string literals, therefore you gotta double it to get a single
backslash into the actual data.
regards, tom lane