--
Seq Scan on test (cost=100.00..140.00 rows=12 width=4)
Filter: (id = 1)
(2 rows)
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astrone
Hi there,
finally, I got time and publish some pictures from PgCon 2009 Developer
Meeting. You can find them on flickr
http://www.flickr.com/photos/obartunov/sets/72157621993479833/
Regards,
Oleg
_
Oleg
Thanks, Bruce !
Oleg
On Thu, 13 Aug 2009, Bruce Momjian wrote:
Peter Eisentraut wrote:
On Thursday 13 August 2009 18:07:51 Alvaro Herrera wrote:
Oleg Bartunov wrote:
Peter,
how to write accented characters in sgml ? Is't not allowed to write
them as is ?
รก for ?, etc. You can&
index'
"""
You should escape the special characters as well as the that appears as
part of the example output using character entitities (& etc.).
Regards,
Oleg
_
Oleg Bartunov,
On Wed, 29 Jul 2009, Peter Eisentraut wrote:
On Tuesday 14 July 2009 22:12:28 Oleg Bartunov wrote:
we'd like to introduce filtering dictionaries support for text search
and new contrib module unaccent, which provides useful example of
filtering dictionary. It finally solves the known pr
vides unaccent() functions, which is a simple
wrapper on unaccent dictionary.
Regards,
Oleg
PS. I hope it's not late for July commitfest !
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
('tst','indices');
to_tsquery
'index':*
(1 row)
=# select 'indexes are very useful'::tsvector @@ to_tsquery('tst','indices');
?column?
--
t
(1 row)
Regards,
Oleg
___
rows)
many thanks,
hans
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://ww
e case I tested here. I wonder why
I can't duplicate it. Can anyone else get the failure?
I also can't reproduce the problems reported, except one you just fixed.
My system is Linux, locale ru_RU.UTF-8.
Regards,
Oleg
_
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Se
On Tue, 31 Mar 2009, Tom Lane wrote:
Oleg Bartunov writes:
How do you think is it right time to upgrade snowball stemmers ?
We didn't change them since 2007.
Probably you should ask the snowball people. I'm not sure if they have
a formal release cycle or not, but if they think t
Hi there !
How do you think is it right time to upgrade snowball stemmers ?
We didn't change them since 2007.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Ster
), which we're testing currently.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su,
e would like to have your opinion what to do with these patches - leave them
for 8.5 or provide them to hackers to review for 8.4.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet
rds,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
| postgres
(15 rows)
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)9
h
(for example, WAL spamming) I think we can apply it.
Other question, why don't improve GiST to allow support of more indexes ?
bitmap indexes could be implemented usin g GiST.
Regards,
Oleg
_____
Oleg Bar
S NULL ON NULL INPUT IMMUTABLE;
use it like
select id, (ts_stat(fts)).* from apod where id=1;
Oleg
On Tue, 9 Dec 2008, Oleg Bartunov wrote:
On Tue, 9 Dec 2008, Dan Chak wrote:
Oleg,
This syntax works fine until I also want to get the "sentence_id" column in
there as well, so that
to run ts_stat separately on multiple tsvectors as I'm doing below.
Is there some generic record access syntax that I can use?
write function
Thanks,
Dan
On Dec 9, 2008, at 3:04 PM, Oleg Bartunov wrote:
try select * from ts_stat()
btw, performance of ts_stat() was greatly impro
issing FROM-clause
entry for table "stat"'. If I say foo.stat.word, I get 'ERROR: schema "foo"
does not exist'.
Any ideas on how to get into these records with resorting to text parsing?
Thanks,
Dan
Regards,
Oleg
=0.00..96821.54 rows=3043
width=12) (actual time=0.040..26.847 rows=7653 loops=1)
Index Cond: (fts @@ to_tsquery('river'::text))
Filter: ((lat < 20::double precision) AND (lat > 10::double precision))
Total runtime: 29.543 ms
(4 rows)
Time: 30.005 ms
Regards,
Ol
rformance for this stupid metric.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http
ately, we unable to verify this parser, so I'm asking about help.
We need usual extensive testing (memory leaking, portability, etc),
regression test and patch for documentation.
Regards,
Oleg
_
Oleg Bartunov
gy to the
web guys.
Being able to insert arbitrary named values, and extracting them
similarly, IMHO works "better" and more naturally than some external
aggregate system built on a column. I know it is a little "outside the
box" thinking, what do you think?
Regards,
, but screamy pug-dog (here it's associated with MySQL:)
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Int
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Sent via pgsql-
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495
to be more reasonable. Any thoughts?
I think we should not change default value because it could change
behaviour of existing applications. I'm not sure if it'd be useful and
possible to define default values in CREATE TEXT SEARCH PARSER
-Sushant.
On Wed, Jul 23, 2008 at 7:44 AM, Oleg Bartun
f any other changes that are needed.
Looks like ready to commit, but documentation is needed.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical I
||, !!), rewrite subsystem
etc. But new operation/types specially designed for phrase search makes needing
to make that work again.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of Astro
answer is to ignore ShortWord
parameter but let me know if the answer is any different.
ShortWord is about headline text, it doesn't affects words in query,
so you can't discard them from query.
-Sushant.
On Thu, 2008-07-17 at 02:53 +0400, Oleg Bartunov wrote:
Sushant,
first, pleas
D]
WWW:
http://www.sigaev.ru/
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTEC
e Webmail/0.1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit
On Mon, 14 Jul 2008 11:47:17 +0400 (MSD), Oleg Bartunov <[EMAIL PROTECTED]>
wrote:
On Mon, 14 Jul 2008, Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Tom Lane wrote
to adding CHECK_FOR_INTERRUPTS there,
I'm just questioning the value.)
regards, tom lane
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Ster
cal sample size.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.
39 Mb538 Mb
Speed: *1.885* ms4.994 ms
Index: ~340 s~200 s
Insert: 72 s/166 s/1
Well, another reason is a index feature-completeness
Regards,
Oleg
_
Oleg Bartunov, Research Scie
e would be also
useful.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su
*sponsor* it. I don't
think this addresses the issues brought up at the meeting.
Peter is right.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomi
On Sun, 1 Jun 2008, David E. Wheeler wrote:
On Jun 1, 2008, at 22:21, Oleg Bartunov wrote:
David,
we wrote contrib module (mchar) for one customer, which ports its
application from mssql to postgres. It does case-insensitive comparison for
new data type 'mchar' and linked wi
l#6cc4c8b0d5be7ce1ac4b600ace7817f5
http://www.icu-project.org/apiref/icu4c/unorm_8h.html#991e0fe6f0d062dd6e8e924517f3f437
I don't really know C, but if that's stuff there, can't we take advantage of
it for proper case-insensitive comparisons (and conversions)?
Thanks,
David
, but I'd guess that's the one
thing none of us have much of.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
risedb.com
Mail sent from my BlackLaptop device
--
Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Regards,
Oleg
On Fri, 11 Apr 2008, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
Slightly offtopic. How to get benefit on tuple level ? For example,
we mark GiST tsearch index as lossy, while for not very big documents it's
actually exact and we could save a lot not rechecking them.
query->size; i++)
if (item[i].type == QI_VAL)
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
I
On Tue, 18 Mar 2008, Jan Urbaski wrote:
Oleg Bartunov wrote:
Josh,
I'm interested in selectivity functions for FTS, proposed by Jan Urbaski.
In case there will be no available mentors for him, I'd work with him.
Oleg
Thanks! Today I'll post a more detailed plan on -hackers e
donate
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +00
/TODO) can be
good gSOC project, for example, research on picksplit algorithm for
intarray, ltree, text search.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg
ttle middleware would help
implement this, and CaseSensitive too.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Inter
queries depending
on the terms occurency.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sa
On Sat, 8 Mar 2008, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
On Sat, 8 Mar 2008, Jan Urbaski wrote:
I have a feeling that in many cases identifying the top 50 to 300 lexemes
would be enough to talk about text search selectivity with a degree of
confidence. At le
On Sat, 8 Mar 2008, Jan Urbaski wrote:
Oleg Bartunov wrote:
Jan,
the problem is known and well requested. From your promotion it's not
clear what's an idea ?
Tom Lane wrote:
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= <[EMAIL PROTECTED]>
writes:
2. Implement better selectivity estimat
an Urbanski
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~me
ssage out: "always specify the
config or never specify the config".
Probably, just stress this in documentation.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
this? Pinging you just so that we do not forget
it in the heap of mails in our inboxes.
Best regards,
On Feb 3, 2008 8:40 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote:
Oleg Bartunov wrote:
On Sat, 2 Feb 2008, Gurjeet Singh wrote:
Hi All,
I just noticed a minor bug in our sea
gards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(49
"gmane.comp.db.postgresql.devel.general" is incorrect. I'll find a more
suitable list.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astron
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternb
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---
On Mon, 17 Dec 2007, Merlin Moncure wrote:
On Dec 17, 2007 3:23 PM, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
Oleg Bartunov wrote:
On Mon, 17 Dec 2007, Magnus Hagander wrote:
just interested do we have a place where developers could post
their availability for contract work
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---(end of
where, so
companies could evaluate it.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROT
ALTER MAPPING FOR asciiword, asciihword, hword_asciipart WITH
thesaurus_simple;
since configuration russian already exists.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru
ation.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +00
it.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83
support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Inst
On Wed, 14 Nov 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
On Wed, 14 Nov 2007, Tom Lane wrote:
Huh? This is just an option for the "simple" dictionary, it's got
nothing to do with thesaurus AFAICS.
I can assign simple dictionary as a normali
On Wed, 14 Nov 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
On Wed, 14 Nov 2007, Tom Lane wrote:
One thought that came to mind is that the option name should be just
"Accept" not "AcceptAll". To me "All" implies that it would accept
On Wed, 14 Nov 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
Let's consider one example - removing accents.
In the past I always recommend people to use regex functions before
to_tsvector conversion to remove accents, but recently I was noticed that
such trick d
consider adding a new feature so late in the
development cycle, but this seems small enough and useful enough
to make an exception. Comments?
regards, tom lane
Regards,
Oleg
_____
Oleg B
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---
gh Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of
(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Regards,
Oleg
__
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone
nd mention in release notes.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.m
On Thu, 11 Oct 2007, andy wrote:
Oleg Bartunov wrote:
Andy,
seems you're a right person for writing migration guide.
Oleg
On Wed, 10 Oct 2007, andy wrote:
Where would be an easy place to find all the renamed functions?
My incomplete list:
http://www.sai.msu.su/~megera
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone
(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical In
On Fri, 14 Sep 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
On Thu, 13 Sep 2007, Bruce Momjian wrote:
I am now satisified with the tsearch2 documentation in SGML and have
marked the item as complete for 8.3.
what's about examples ? They certainly need updati
;tsearch/ts_utils.h"
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83,
comes very simple task.
It's possible to eliminate istrue flag, but it's needed to implement
algorithm to execute tsquery over continuos part of document, not over whole
document.
Regards,
Oleg
_____
On Mon, 10 Sep 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
On Mon, 10 Sep 2007, Simon Riggs wrote:
Can we include that functionality now?
This could be realized very easyly using dict_strict, which returns
only known words, and mapping contains only this dictiona
On Mon, 10 Sep 2007, Simon Riggs wrote:
On Mon, 2007-09-10 at 16:35 +0400, Oleg Bartunov wrote:
On Mon, 10 Sep 2007, Simon Riggs wrote:
On Mon, 2007-09-10 at 16:10 +0400, Oleg Bartunov wrote:
On Mon, 10 Sep 2007, Simon Riggs wrote:
It seems possible to write your own functions to support
own.
yes, there is room to improve support of very long posting lists
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russi
On Mon, 10 Sep 2007, Simon Riggs wrote:
On Mon, 2007-09-10 at 16:10 +0400, Oleg Bartunov wrote:
On Mon, 10 Sep 2007, Simon Riggs wrote:
It seems possible to write your own functions to support various
possibilities with text search.
One of the more common thoughts is to have a list of words
, so if your mapping contains
only one dictionary, this dictionary will control what words to index.
While dict_synonym is good for not big list I'd write separate dictionary
with fast lookup.
Regards,
Oleg
____
y now?
This could be realized very easyly using dict_strict, which returns
only known words, and mapping contains only this dictionary. So,
feel free to write it and submit.
Regards,
Oleg
_
Oleg Bartunov, Res
Hmm,
After renewing session I've got working ispell dictionary. I don't
remember exactly if such behaviour is what we wanted.
Oleg
On Sun, 9 Sep 2007, Heikki Linnakangas wrote:
Oleg Bartunov wrote:
seems something is broken in ispell dictionary (CVS HEAD).
event=# CREATE T
On Sun, 9 Sep 2007, Oleg Bartunov wrote:
Oh, my god, I see we dictate extensions !
STATEMENT: CREATE TEXT SEARCH DICTIONARY en_ispell (
TEMPLATE = ispell,
DictFile = englishDict,
AffFile = englishAff,
StopWords = englishStop
xize
FROM pg_ts_dict
WHERE dict_name = 'ispell_template'
);
apod=# select lexize('en_ispell','stars');
lexize
{star}
Regards,
Oleg
_
Oleg Bartunov, Research Scienti
quot;: No such file or
directory
Folk, this is too much ! Now, we dictate extensions '.dict, .affix, .stop',
what else ?
Does it defined by ispell template only, or it's global requirements ?
Regards,
Oleg
___
with thesaurus dictionary, so it
certainly needs to be rewritten in C. We left rewriting it for future.
access any unnecessary dictionaries. It seems wrong to install
dictionaries in databases where they won't work in the first place, but
I don't see an easy fix for that. Any comme
ll,simple} | simple: {vody}(13 rows)
This query returned true in 8.2 and now:
postgres=# select to_tsvector('cs','P??li? ?lut? k?? se napil ?lut?vody') @@
to_tsquery('cs','nap?t'); ?column?-- f(1 row)
RegardsPavel Stehule
Regards,
TEXT SEARCH DICTIONARY cz1(TEMPLATE = ispell,DictFile= "csczutf");ERROR: could not
open dictionary file"/usr/local/pgsql/share/tsearch_data/csczutf.dict": nen? souborem aniadres??em
regardsPavel Stehule
Regards,
Oleg
__
tion.
Thanks a lot,
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +
e to be parsed over and over again for each row.
No, internally the TEXT string would be converted to something the
system could deal with for that query, which is probably what 99% of all
queries are going to do anyway by calling to_tsquery().
Regards,
Oleg
___
Hi there,
I notice, that not all functions were renamed, for example,
strip(), setweight(), numnode()
Is this intentional ?
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru
s, but it would be nice to
get the API right even though there is some work to do. I can write a
patch if no-one objects.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
for more elegant solution.
Or am I totally wrong?
Alex.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Regards,
Oleg
_____
Oleg B
.
They are available from openoffice.org
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTEC
301 - 400 of 976 matches
Mail list logo