From: Mubarik, Aiysha <amubarik@microstrategy.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Tablesample Function on Postgres 9.1
Date: Wed, 29 Aug 2012 19:48:48 +0000
Message-ID: <202999ABC03E814AA4D027664CAC2C8F11B0DABD@PROD-EXCH-M1.corp.microstrategy.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: amubarik@microstrategy.com
Subject: Re: Tablesample Function on Postgres 9.1
In-Reply-To: <202999ABC03E814AA4D027664CAC2C8F11B0DABD@PROD-EXCH-M1.corp.microstrategy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox