Обсуждение: Tablesample Function on Postgres 9.1
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
"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
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