Search Postgresql Archives

Re: Full text search prefix matching

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 16.12.2014, at 17:09, Vincent Veyron <vv.lists@xxxxxxxxxx> wrote:

> On Tue, 16 Dec 2014 14:59:51 +0200
> Heikki Rauhala <heikki.rauhala@xxxxxxxxxx> 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




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux