Horton

Re: string_to_array eats too much memory?

Teodor Sigaev <teodor@sigaev.ru>

View thread View on postgr.es
From: Teodor Sigaev <teodor@sigaev.ru>
To: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: pgsql-hackers@postgresql.org
Date: 2006-11-08T15:54:28Z
Lists: pgsql-hackers 
> 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/