dbTalk Databases Forums  

[SQL] Tablesample Function on Postgres 9.1

mailing.database.pgsql-sql mailing.database.pgsql-sql


Discuss [SQL] Tablesample Function on Postgres 9.1 in the mailing.database.pgsql-sql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mubarik, Aiysha
 
Posts: n/a

Default [SQL] Tablesample Function on Postgres 9.1 - 08-29-2012 , 02:48 PM






Hi,

I am trying to run a simple query to test out the tablesample function, butin postgres 9.1 it does not recognize the function. As from the wiki it seems like tablesample is supported (https://wiki.postgresql.org/wiki/TAB...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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.