On Fri, Feb 27, 2004 at 12:06:58PM -0000, Simon Windsor wrote: > Hi > > I have moved an application from MySQL to PgSQL, and after the making > changes I thought all was ok. > > However, I have just realised that > > Where A = 'STRING' > > Is not the same as > > Where A ='String'
This is standard SQL. It's possible to use functions inside index definitions, so you can force case and search on the same. Michael -- Michael Darrin Chaney [EMAIL PROTECTED] http://www.michaelchaney.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster