Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T6oYR-0001xU-48 for pgsql-sql@postgresql.org; Wed, 29 Aug 2012 20:07:59 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T6oYP-0002hW-VA for pgsql-sql@postgresql.org; Wed, 29 Aug 2012 20:07:58 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q7TK7vG5001498; Wed, 29 Aug 2012 16:07:57 -0400 (EDT) From: Tom Lane To: "Mubarik, Aiysha" cc: "pgsql-sql@postgresql.org" Subject: Re: Tablesample Function on Postgres 9.1 In-reply-to: <202999ABC03E814AA4D027664CAC2C8F11B0DAE0@PROD-EXCH-M1.corp.microstrategy.com> References: <202999ABC03E814AA4D027664CAC2C8F11B0DAE0@PROD-EXCH-M1.corp.microstrategy.com> Comments: In-reply-to "Mubarik, Aiysha" message dated "Wed, 29 Aug 2012 19:52:11 -0000" Date: Wed, 29 Aug 2012 16:07:56 -0400 Message-ID: <1497.1346270876@sss.pgh.pa.us> X-Pg-Spam-Score: -2.1 (--) X-Archive-Number: 201208/27 X-Sequence-Number: 36798 "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