From: | chris(dot)gamble(at)CPBINC(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: read this and puke |
Date: | 2002-06-13 22:13:46 |
Message-ID: | 00CA54A79070D411A9E20090273CEF1C14F333@inet1.cpbinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think a big bonus for postgres would be more and better FAQ's. Several
issues that I have run into trying to transition myself and my developers
from MSSQL and MySQL have only been resolved through hours of usenet
searches (at least until I subscribed to the pgsql-general system.)
I admit that I may just not know where to find all of the good dirt on
postgres, but that is a large part of the problem.
Some good questions that I have dealt with since starting postgres:
when I run a query comparing a float8 > 3343432, why will it not use the
index. The best answer I found is that I have to quote the number (leaving
it unquoted the parser complains about some float8 compirson not defined.).
case sensitive searches. I have seen the FAQ on this, but for my developers
this has been hard to swallow. It has even caused me a great deal of
headaches (i need a like search for address, city and state in case
insensitive, but to date just deal with only using a UCASE(state) index -- a
little on the slow side). This would be useful to have stronger comparisons
against other leading db's (i have heard that oracle suffers this problem as
well.)
This being said, i personally think that postgres is a VERY powerful
database solution that I enjoy using.
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Carter | 2002-06-13 22:20:07 | large database on postgres |
Previous Message | Bruce Momjian | 2002-06-13 22:11:34 | Re: Contrib reindex script: |