Tablesample Function on Postgres 9.1

From: "Mubarik, Aiysha" <amubarik(at)microstrategy(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Tablesample Function on Postgres 9.1
Date: 2012-08-29 19:52:11
Message-ID: 202999ABC03E814AA4D027664CAC2C8F11B0DAE0@PROD-EXCH-M1.corp.microstrategy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2012-08-29 20:07:56 Re: Tablesample Function on Postgres 9.1
Previous Message Mubarik, Aiysha 2012-08-29 19:48:48 Tablesample Function on Postgres 9.1