[SQL] 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
Re: [SQL] Tablesample Function on Postgres 9.1
"Mubarik, Aiysha" 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 -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Tablesample Function on Postgres 9.1
On 08/30/2012 04:07 AM, Tom Lane wrote: "Mubarik, Aiysha" 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. Wiki page updated to make that clearer. -- Craig Ringer -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
