Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T6oFx-00018k-QQ for pgsql-sql@postgresql.org; Wed, 29 Aug 2012 19:48:54 +0000 Received: from mailgate3.microstrategy.com ([199.255.80.101]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T6oFv-0002QF-Qr for pgsql-sql@postgresql.org; Wed, 29 Aug 2012 19:48:52 +0000 X-AuditID: 0a0d41d8-b7f986d0000012d0-66-503e72211c8a Received: from PROD-EXCH-H1.corp.microstrategy.com (prod-exch-h1.corp.microstrategy.com [10.26.4.40]) (using TLS with cipher AES128-SHA (AES128-SHA/128 bits)) (Client did not present a certificate) by mailgate3.microstrategy.com (Symantec Messaging Gateway) with SMTP id 69.E8.04816.1227E305; Wed, 29 Aug 2012 15:48:50 -0400 (EDT) Received: from PROD-EXCH-M1.corp.microstrategy.com ([fe80::7c27:3ef9:e4ae:3bb6]) by PROD-EXCH-H1.corp.microstrategy.com ([fe80::681e:5457:7c96:5e77%20]) with mapi id 14.01.0379.000; Wed, 29 Aug 2012 15:48:49 -0400 From: "Mubarik, Aiysha" To: "pgsql-sql@postgresql.org" Subject: Tablesample Function on Postgres 9.1 Thread-Topic: Tablesample Function on Postgres 9.1 Thread-Index: Ac2GHXLGd4zA4onfS8C/bFTl9VfQ/w== Date: Wed, 29 Aug 2012 19:48:48 +0000 Message-ID: <202999ABC03E814AA4D027664CAC2C8F11B0DABD@PROD-EXCH-M1.corp.microstrategy.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.21.44.149] Content-Type: multipart/alternative; boundary="_000_202999ABC03E814AA4D027664CAC2C8F11B0DABDPRODEXCHM1corpm_" MIME-Version: 1.0 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFmpgluLIzCtJLcpLzFFi42LhkmLR0FUqsgswOLiI02La/AksDoweF/ZN Yw9gjOK2SUosKQvOTM/Tt0vgzjj4Yj1LwXapil3HP7I0MK4X72Lk5JAQMJFYve4DM4QtJnHh 3nq2LkYuDiGBC0wSR882gCWEBG4zSuxZaQ1iswE1/FmyGKiIg0NEwFLi5G8RkLCwgK7EvnkP wMpFBIwkTr44BmXrSbz+sJcJxGYRUJW4PXMemM0rECXx4eU5NhCbEWjv91NrwOLMAuISt57M Z4K4R0BiyZ7zULeJSrx8/I8VwlaQ+LSygxmiPl9i59aFrBAzBSVOznzCMoFRaBaSUbOQlM1C UraAkXkVo1RxcmJeXmqRoV5uZnJRfnFJUWJJanqlXnJ+7iZGUPDyOt7YwbjhqOEhRiYOThDB JdXAyKp06pbdoxImdaUdXdN4r3ZPFtBZ9TTJO+tzo9tnz5SwiYmq0apTPx7YwJvssbzzr8Xr yW9uLtz+kUvgZRDLjOkO4i83ZwTqn5V0snw0U7U8fl1RyucjTXMYlr0wZHim17taqzNZvSk+ 5Mj7gw9bDhQsbPXael15xzp7/95QYdu7JlLCAeFTlFiKMxINtZiLihMBukIZbhMCAAA= X-Pg-Spam-Score: -2.1 (--) X-Archive-Number: 201208/29 X-Sequence-Number: 36800 --_000_202999ABC03E814AA4D027664CAC2C8F11B0DABDPRODEXCHM1corpm_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 se= ems like tablesample is supported (https://wiki.postgresql.org/wiki/TABLESA= MPLE_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 --_000_202999ABC03E814AA4D027664CAC2C8F11B0DABDPRODEXCHM1corpm_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I am trying to run a simple query to test out the ta= blesample function, but in postgres 9.1 it does not recognize the function.= As from the wiki it seems like tablesample is supported (https://wiki.postgre= sql.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

--_000_202999ABC03E814AA4D027664CAC2C8F11B0DABDPRODEXCHM1corpm_--