Re: [BUGS] BUG #6314: The like command does not handle a long string of special chars

2011-12-02 Thread Magnus Hagander
On Thursday, December 1, 2011, Tom Lane wrote: > d.reri...@healthcareoss.com writes: > > Simply set a varchar field in your db to the following string: > > !"#$%'()*+,-/:;=?@[\]^_`{|}~&<> > > > I know, I know, who would do this, right? Well, its for a certification. > > The like command works

Re: [BUGS] BUG #6314: The like command does not handle a long string of special chars

2011-12-01 Thread Tom Lane
d.reri...@healthcareoss.com writes: > Simply set a varchar field in your db to the following string: > !"#$%'()*+,-/:;=?@[\]^_`{|}~&<> > I know, I know, who would do this, right? Well, its for a certification. > The like command works fine up with escapes up to: > !"#$%''()*+,-/:;=?@[% Doesn

Re: [BUGS] BUG #6314: The like command does not handle a long string of special chars

2011-12-01 Thread Kevin Grittner
wrote: > Simply set a varchar field in your db to the following string: > !"#$%'()*+,-/:;=?@[\]^_`{|}~&<> Do you have standard_conforming_strings = on? > The like command works fine up with escapes up to: > !"#$%''()*+,-/:;=?@[% > Notice, I added the % to the end. However, if you go any

[BUGS] BUG #6314: The like command does not handle a long string of special chars

2011-12-01 Thread d . rericha
The following bug has been logged on the website: Bug reference: 6314 Logged by: David Rericha Email address: d.reri...@healthcareoss.com PostgreSQL version: 8.4.5 Operating system: OpenSuSE 11.4 64-bit Description: Simply set a varchar field in your db to the followi