| From: | Heikki Rauhala <heikki(dot)rauhala(at)reaktor(dot)fi> |
|---|---|
| To: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Full text search prefix matching |
| Date: | 2014-12-17 07:38:18 |
| Message-ID: | 1F3A1F65-5C71-4B09-85A0-BD7317CE7C13@reaktor.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 16.12.2014, at 17:09, Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> wrote:
> On Tue, 16 Dec 2014 14:59:51 +0200
> Heikki Rauhala <heikki(dot)rauhala(at)reaktor(dot)fi> wrote:
>
> Hi Heikki,
>
> There is a typo :
>
>> create materialized view name_fulltext as
>
> ERREUR: erreur de syntaxe sur ou près de « materialized »
> LIGNE 1 : create materialized view name_fulltext as
>
I forgot to mention the postgres version, which is 9.3. Materialized views were introduced in 9.3 and are important to me in this case, because they can be indexed.
Next time I’ll include both the version and the full output.
Best regards,
- Heikki Rauhala
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2014-12-17 07:49:24 | Re: 9.3.5 failing to compile with dtrace on FreeBSD 10.1 |
| Previous Message | harpagornis | 2014-12-17 07:08:52 | Re: SSL Certificates in Windows 7 & Postgres 9.3 |