subject:"\[GENERAL\] Get IP addresses from tsvectors"

Re: [GENERAL] Get IP addresses from tsvectors

2009-03-12 Thread Lubomir Petrov

Hi, Maybe you can use something like the following: test=# select * from t1; t --- 'leas':4 'return':2 'leas':2 'found':1 'address':5 'hardwar':4 '65.110.236.113':6 '00':3 '17':4 '1d':7 '27'

[GENERAL] Get IP addresses from tsvectors

2009-03-09 Thread Justin Funk

Greetings, I have a table with a column with type tsvector. It contains the result of to_tsvector() of varchar field in the table. What I'd like to do is be able to search through the table and find all of the distinct IP addresses. Any idea how to turn: SELECT message_index_col FROM systemevents