Postgres Pro
Downloads
Home   >   mailing lists

Re: string_to_array eats too much memory? - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: string_to_array eats too much memory?
Date
Msg-id 4551FDB4.6010101@sigaev.ru
Whole thread Raw
In response to Re: string_to_array eats too much memory?  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Tree view 
> Is this documented somewhere? Also I noticed that tsearch2 treats ":"
> as a special character. Are there any special characters? If so where
> are they documented?

You can avoid confusions with special character by quoting:
# select '''wow:'''::tsvector; tsvector
---------- 'wow:'
(1 row)

':' is separator of lexeme and its position information
-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/

pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: string_to_array eats too much memory?
Next
From: Teodor Sigaev
Date:
Subject: Re: string_to_array eats too much memory?