Thread: Tablesample Function on Postgres 9.1

Tablesample Function on Postgres 9.1

From

"Mubarik, Aiysha"

Date:

30 August 2012, 10:06:29

<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>