Full Text Search : Parse date - Mailing list pgsql-general

From Mickaël DA ROCHA
Subject Full Text Search : Parse date
Date
Msg-id 13B1BB0E66E3BC4FAF5AB8382499F6E41A4466@exchange2003.documentnumerique.fr
Whole thread Raw
Responses Re: Full Text Search : Parse date  (Oleg Bartunov <oleg@sai.msu.su>)
Re: Full Text Search : Parse date  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general

Hello,

 

We have a document that contains a date (french date for example) : 28-04-2009 (28 April 2009)

 

In the to_tsvector function, it is noted as :

’-04’:2 ‘-2009’:3 ’28’:1

 

Is it possible to have something like that (a date) :

‘28-04-2009’:1

 

Does a Parser Token Type for date exists ? (« DD-MM-YYYY », « DD-MM-YY », « YYYY-MM-DD », « YY-MM-DD », with « - » or « / »)

(we haven’t found it)

 

Is there another solution ? Any clue ?

 

Thank You

 

 

 

pgsql-general by date:

Previous
From: Jiří Pavlovský
Date:
Subject: deadlock on simple update
Next
From: Andy Colson
Date:
Subject: Re: Workqueue performance