[SQL] Tablesample Function on Postgres 9.1

2012-08-30 Thread Mubarik, Aiysha
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 * fr

Re: [SQL] Tablesample Function on Postgres 9.1

2012-08-29 Thread Craig Ringer
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/TABLESAM

Re: [SQL] Tablesample Function on Postgres 9.1

2012-08-29 Thread Tom Lane
"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 wi

[SQL] Tablesample Function on Postgres 9.1

2012-08-29 Thread Mubarik, Aiysha
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 * fr