Re: [GENERAL] like query backslash

2007-01-15 Thread ksherlock
Sim Zacks wrote: > To retrieve the above example, I needed to query: > select * from filetable where filename like 'serverdir%' > > Is this a bug or is there a reason for this? > > Sim There's a reason. With like queries, if you want to search for the literal characters % or ? they

Re: [GENERAL] like query backslash

2007-01-14 Thread Shoaib Mir
This is how version below 8.2 used to handled backslashes, but with 8.2 you can now handle the backslashes using a setting in the postgresql.conf file: standard_conforming_strings (boolean) This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL