Hi,
I am running Postgresql ver 6.5.1 on an SGI (Irix).
I am trying to write a query to return some top scoring items, using a
GROUP BY clause, however, I am having trouble with "empty" results. For
example:
htg=> SELECT LocusID, Score FROM Match
htg-> WHERE SeqID=4358;
locusid|score
---+-
Hi,
For case insensitive you must use the regexp search as follow :
SELECT title, firstname, lastname, description FROM stuff
WHERE title *~ '.*.*' AND firtsname *~ '.*.*';
>
> P.S.: as far as I know there is no locale for windows-1251 and,
> unfortunately, I can't store data in koi8-r w
Greetings,
I store text data in windows-1251 encoding in my pgSQL database
and when I execute SQL command like
SELECT title, firstname, lastname, description FROM stuff
WHERE title LIKE '%%' AND firtsname LIKE '%%'
AND lastname LIKE '%%' AND description LIKE '%%'
the response comes reall
