Re: [ADMIN] Standards for Postgres Installation Question?

2009-04-15 Thread Scott Marlowe
On Wed, Apr 15, 2009 at 11:29 AM, DM wrote: > Hi All, > > Is there any standards for installing postgres in a certain directory? or > What is the standard installation path to install postgres. > > If I have to run two different versions of postgres on the same machine, how > should I install post

[ADMIN] Standards for Postgres Installation Question?

2009-04-15 Thread DM
Hi All, Is there any standards for installing postgres in a certain directory? or What is the standard installation path to install postgres. If I have to run two different versions of postgres on the same machine, how should I install postgres? What is the standards for this? By using RPM it alw

Re: [ADMIN] case insensitive like searches

2009-04-15 Thread Kenneth Marshall
In 8.4 there is a citext contrib module that should do the trick. Cheers, Ken On Mon, Apr 13, 2009 at 09:59:11AM -0600, Mark Dueck wrote: > Is there a way to make Postgres do case insensitive like searches? I > know you can use ilike instead, but I don't have control of the > software. Is there

[ADMIN] case insensitive like searches

2009-04-15 Thread Mark Dueck
Is there a way to make Postgres do case insensitive like searches? I know you can use ilike instead, but I don't have control of the software. Is there a plan to enable this in the future? Can I recompile Postgres to make like searches do the same as ilike, or is it easier to create a new chara