Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tablesample Function on Postgres 9.1

Tablesample Function on Postgres 9.1

From
"Mubarik, Aiysha"
Date:
<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>

Re: Tablesample Function on Postgres 9.1

From
Tom Lane
Date:
"Mubarik, Aiysha" <amubarik@microstrategy.com> writes:
> 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)

Sorry, that wiki page is just blue-sky speculation.  If the feature were
supported, you would find it in the main documentation.
        regards, tom lane

Re: Tablesample Function on Postgres 9.1

From
Craig Ringer
Date:
On 08/30/2012 04:07 AM, Tom Lane wrote:
> "Mubarik, Aiysha" <amubarik@microstrategy.com> writes:
>> I am trying to run a simple query to test out the tablesample function, but in postgres 9.1 it does not recognize
thefunction. As from the wiki it seems like tablesample is supported
(https://wiki.postgresql.org/wiki/TABLESAMPLE_Implementation)
> Sorry, that wiki page is just blue-sky speculation.  If the feature were
> supported, you would find it in the main documentation.
Wiki page updated to make that clearer.

--
Craig Ringer