Re: Full Text Search : Parse date

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Mickaël DA ROCHA <MICKAEL(at)documentnumerique(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Full Text Search : Parse date
Date: 2010-05-13 02:31:17
Message-ID: 4BEB6475.3060608@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/05/10 21:19, Mickaël DA ROCHA wrote:
> 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

You'll probably *also* want to continue to output the current year,
month and day (though probably without hyphens), so people can still
search for (eg) "2009".

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh.Vote 2010-05-13 02:41:14 Unpivot / uncrosstab support?
Previous Message Marc G. Fournier 2010-05-13 00:04:42 Re: List traffic