Postgres Pro
Downloads
Home   >   mailing lists

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
Tree view 
<div class="WordSection1"><p class="MsoNormal">Hi, <p class="MsoNormal"> <p class="MsoNormal">I am trying to run a
simplequery to test out the tablesample function, but in postgres 9.1 it does not recognize the function. As from the
wikiit seems like tablesample is supported (<a
href="https://wiki.postgresql.org/wiki/TABLESAMPLE_Implementation">https://wiki.postgresql.org/wiki/TABLESAMPLE_Implementation</a>)
<pclass="MsoNormal"> <p class="MsoNormal">The query I am trying to run is <p class="MsoNormal"> <p
class="MsoNormal">select* from testtable TABLESAMPLE SYSTEM(10);<p class="MsoNormal"> <p class="MsoNormal">Is table
samplenot supported in Postgres9.1?<p class="MsoNormal"> <p class="MsoNormal">Thanks!<p class="MsoNormal">-Aiysha</div>

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"