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:48:48
Message-ID: 202999ABC03E814AA4D027664CAC2C8F11B0DABD@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

Browse pgsql-sql by date

  From Date Subject
Next Message Mubarik, Aiysha 2012-08-29 19:52:11 Tablesample Function on Postgres 9.1
Previous Message Gary Stainburn 2012-08-22 10:49:53 Re: generated dates from record dates - suggestions