Tablesample Function on Postgres 9.1 - Mailing list pgsql-sql

From Mubarik, Aiysha
Subject Tablesample Function on Postgres 9.1
Date
Msg-id 202999ABC03E814AA4D027664CAC2C8F11B0DABD@PROD-EXCH-M1.corp.microstrategy.com
Whole thread Raw
List pgsql-sql

Hi,

 

I am trying to run a simple query to test out the tablesample function, but in postgres 9.1 it does not recognize the function. As from the wiki it seems like tablesample is supported (https://wiki.postgresql.org/wiki/TABLESAMPLE_Implementation)

 

The query I am trying to run is

 

select * from testtable TABLESAMPLE SYSTEM(10);

 

Is table sample not supported in Postgres9.1?

 

Thanks!

-Aiysha

pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Tablesample Function on Postgres 9.1
Next
From: Wayne Cuddy
Date:
Subject: locks and "select for update"