But tsvector recognices email format as natural. And I'm not looking for a
substring. Please see the queries are incremental with the search string,
and see last four results ... I think some think it's no working properly.
El 14 de marzo de 2012 19:05, Daniel Vázquez escribió:
>
Hi guys, I'm going to crazy about FTS with prefix agains email values on
tsvector. Follow how to reproduce:
For the next tsvector:
=# select to_tsvector('u...@company.com')
to_tsvector
--
'u...@company.com':1
I expects TRUE for all next tsqueryes:
select to_tsvector('u
Hi guys!
There's a way to mix characters with utf-8 characters on the same query.
Some thing like this:
Character: "." (dot)
UTF-8: *\u002E*
(requisite* can't use regex*)
For this normal query:
select * from foo where email like 'em...@company.com '
Some thing like this:
select * from foo w
Hi guys!
I'want to run unaccent function with a custom unaccent dictionary
I know that we can do:
Select unaccent('áéíóúñ')
Select unaccent('unaccent', 'áéíóúñ')
Select unaccent('custom_unaccent', 'áéíóúñ)
PG Docs say that we can set the rules for default installed unaccent
dictionary:
ALTER
THX all !!
My fault is I set the $PGDATA enviroment variable in
/etc/sysconfig/pgsql/**postgresql
like usual in 8.4
renaming the file to postgresql-9.1 solve the isue.
Thanks guys!
El 9 de febrero de 2012 22:25, Daniel Vázquez escribió:
> Hi!
>
> I've set my PGDATA variable in pr
Hi!
I've set my PGDATA variable in profile
export PGDATA=/home/mydata/pgsql/data
Testing variable for correct set in enviroment
$ echo $PGDATA
/home/mydata/pgsql/data
but when execute:
$ sudo /etc/init.d/postgresql-9.1 initdb
or execute:
$ sudo /etc/init.d/postgresql-9.1 initdb -D /home/mydata/
Hi guys!
Full text search, searches by lexemes, this minds that if you are finding
for "gato" word you are really finding for {gat} lexeme.
I you construct vectors for the words "gato", "gatos", "gata", "gatas", all
have the same lexema {gat}
Then the search "gato" that is to say the search {gat}
Hi guys!
Full text search, searches by lexemes, this minds that if you are finding
for "gato" word you are really finding for {gat} lexeme.
I you construct vectors for the words "gato", "gatos", "gata", "gatas", all
have the same lexema {gat}
Then the search "gato" that is to say the search {gat}
