From amubarik@microstrategy.com Wed Aug  29 19:48:54 2012
Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <prvs=658878a5b9=amubarik@microstrategy.com>)
	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 <prvs=658878a5b9=amubarik@microstrategy.com>)
	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" <amubarik@microstrategy.com>
To: "pgsql-sql@postgresql.org" <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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri","sans-serif";}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi, <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">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 (<a href=3D"https:=
//wiki.postgresql.org/wiki/TABLESAMPLE_Implementation">https://wiki.postgre=
sql.org/wiki/TABLESAMPLE_Implementation</a>)
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">The query I am trying to run is <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">select * from testtable TABLESAMPLE SYSTEM(10);<o:p>=
</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Is table sample not supported in Postgres9.1?<o:p></=
o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks!<o:p></o:p></p>
<p class=3D"MsoNormal">-Aiysha<o:p></o:p></p>
</div>
</body>
</html>

--_000_202999ABC03E814AA4D027664CAC2C8F11B0DABDPRODEXCHM1corpm_--




From amubarik@microstrategy.com Wed Aug  29 19:52:14 2012
Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <prvs=7588db58fe=amubarik@microstrategy.com>)
	id 1T6oJC-0004zY-RH
	for pgsql-sql@postgresql.org; Wed, 29 Aug 2012 19:52:14 +0000
Received: from mailgate3.microstrategy.com ([199.255.80.101])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <prvs=7588db58fe=amubarik@microstrategy.com>)
	id 1T6oJB-0002US-BG
	for pgsql-sql@postgresql.org; Wed, 29 Aug 2012 19:52:14 +0000
X-AuditID: 0a0d41d8-b7f986d0000012d0-72-503e72eca95b
Received: from PROD-EXCH-H2.corp.microstrategy.com
	(prod-exch-h2.corp.microstrategy.com [10.26.4.41])
	(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 8A.F8.04816.CE27E305; Wed, 29 Aug 2012 15:52:12 -0400 (EDT)
Received: from PROD-EXCH-M1.corp.microstrategy.com
	([fe80::7c27:3ef9:e4ae:3bb6]) by PROD-EXCH-H2.corp.microstrategy.com
	([fe80::bd:757b:7b34:92d5%19]) with mapi id 14.01.0379.000;
	Wed, 29 Aug 2012 15:52:12 -0400
From: "Mubarik, Aiysha" <amubarik@microstrategy.com>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Tablesample Function on Postgres 9.1
Thread-Topic: Tablesample Function on Postgres 9.1
Thread-Index: Ac2GHXLGd4zA4onfS8C/bFTl9VfQ/wAAk5gQ
Date: Wed, 29 Aug 2012 19:52:11 +0000
Message-ID: 
 <202999ABC03E814AA4D027664CAC2C8F11B0DAE0@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_202999ABC03E814AA4D027664CAC2C8F11B0DAE0PRODEXCHM1corpm_"
MIME-Version: 1.0
X-Brightmail-Tracker: 
 H4sIAAAAAAAAA+NgFmpgluLIzCtJLcpLzFFi42LhkmLR1H1TZBdg8HixlcW0+RNYHBg9Luyb
	xh7AGMVtk5RYUhacmZ6nb5fAnTF591OWgi7pint/nzM3MH4X72Lk5JAQMJE4+2YtO4QtJnHh
	3no2EFtI4AKTxLnd/F2MXED2TUaJjRPbwYrYgBr+LFkMVMTBISJgKXHytwhIWFhAV2LfvAfM
	ILaIgJHEyRfH4Ow1ExYxgdgsAqoSTx6eYQGxeQWiJLY3zGQEsRmB9n4/tQashllAXOLWk/lM
	EPcISCzZc54ZwhaVePn4HyuErSDxaWUHM0R9vsTprofsEDMFJU7OfMIygVFoFpJRs5CUzUJS
	toCReRWjVHFyYl5eapGhXm5mclF+cUlRYklqeqVecn7uJkZQ8PI63tjBuOGo4SFGJg5OEMEl
	1cBYLW/SEvqw5dPSdsXuj5t6Kpp2Klh/NC90NvwQ6OkdvnmdyUGtvKMrik7XNLh0ncxa/LNr
	xSfeWWwKXC9yGWdF5AgYNyY096+MPKA/c3m8UuwUoZKjOqaz3upItf04OKnZNjbg4VFevf1r
	Ar7d3MPdJ9+wQy3mubDk/Tu6Pz6GLT3TfvhQSoASS3FGoqEWc1FxIgBHSKKFEwIAAA==
X-Pg-Spam-Score: -2.1 (--)
X-Archive-Number: 201208/26
X-Sequence-Number: 36797

--_000_202999ABC03E814AA4D027664CAC2C8F11B0DAE0PRODEXCHM1corpm_
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_202999ABC03E814AA4D027664CAC2C8F11B0DAE0PRODEXCHM1corpm_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi, <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">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 (<a href=3D"https:=
//wiki.postgresql.org/wiki/TABLESAMPLE_Implementation">https://wiki.postgre=
sql.org/wiki/TABLESAMPLE_Implementation</a>)
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">The query I am trying to run is <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">select * from testtable TABLESAMPLE SYSTEM(10);<o:p>=
</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Is table sample not supported in Postgres9.1?<o:p></=
o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks!<o:p></o:p></p>
<p class=3D"MsoNormal">-Aiysha<o:p></o:p></p>
</div>
</body>
</html>

--_000_202999ABC03E814AA4D027664CAC2C8F11B0DAE0PRODEXCHM1corpm_--




From tgl@sss.pgh.pa.us Wed Aug  29 20:07:59 2012
Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) 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 <tgl@sss.pgh.pa.us>) 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 <tgl@sss.pgh.pa.us>
To: "Mubarik, Aiysha" <amubarik@microstrategy.com>
cc: "pgsql-sql@postgresql.org" <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" <amubarik@microstrategy.com>
	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" <amubarik@microstrategy.com> 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




From ringerc@ringerc.id.au Thu Aug  30 02:20:39 2012
Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1T6uN5-0004P6-B8
	for pgsql-sql@postgresql.org; Thu, 30 Aug 2012 02:20:39 +0000
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1T6uN0-0007q2-Jo
	for pgsql-sql@postgresql.org; Thu, 30 Aug 2012 02:20:38 +0000
Received: by dady13 with SMTP id y13so844910dad.19
	for <pgsql-sql@postgresql.org>; Wed, 29 Aug 2012 19:20:32 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:cc:subject:references
	:in-reply-to:content-type:content-transfer-encoding
	:x-gm-message-state;
	bh=iFbMAy9vF91wKDZgMKh1uxPitDtP4+NrGE7w1BOn5Is=;
	b=Mo1RDKXwzW0qMnY5cRRmYFSuOZ7np61QutQxKsJZIZmQm2YSWjLSTq5j/btlm/FXlh
	AoDa9jrnbwt3GIXy1Nc7cGNakibWxPU03vYz1sKwnhal8Yp2medq2RH3GYLKY984sbbA
	GiIdyTa1nwPtgCbCNtRv34DuCqelzmZcjc5OEbdsd2cKpPq6MRVIKIdhT/xI1BmyT9Jn
	MLk4e/x+D/tw/ywQF1becDgCJVva1U5C29f6rbe0oE3gk7befuM1VhOnkz1omv+z0pzz
	MRS2igdKbHRPWg1DJxK0eelV1TDx60n8JLJw/08igEfBRF2RN8/df6tuk9J02u4p0n6V
	f6yA==
Received: by 10.68.138.169 with SMTP id qr9mr8607725pbb.27.1346293232103;
	Wed, 29 Aug 2012 19:20:32 -0700 (PDT)
Received: from ayaki.localdomain (office1.postnewspapers.com.au.
	[150.101.171.128])
	by mx.google.com with ESMTPS id or1sm540834pbb.10.2012.08.29.19.20.29
	(version=SSLv3 cipher=OTHER); Wed, 29 Aug 2012 19:20:31 -0700 (PDT)
Message-ID: <503ECDEB.5070009@ringerc.id.au>
Date: Thu, 30 Aug 2012 10:20:27 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:14.0) Gecko/20120717 Thunderbird/14.0
MIME-Version: 1.0
CC: "Mubarik, Aiysha" <amubarik@microstrategy.com>,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Tablesample Function on Postgres 9.1
References: 
 <202999ABC03E814AA4D027664CAC2C8F11B0DAE0@PROD-EXCH-M1.corp.microstrategy.com>
	<1497.1346270876@sss.pgh.pa.us>
In-Reply-To: <1497.1346270876@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Gm-Message-State: 
 ALoCoQlyJ2aoZQaPbrtuNwB5wSc06SyQHeO+XCejwWXSD38wtx5CAHpNEyYdwF08shBXfRlptJcV
X-Pg-Spam-Score: -0.9 (/)
X-Archive-Number: 201208/28
X-Sequence-Number: 36799

On 08/30/2012 04:07 AM, Tom Lane wrote:
> "Mubarik, Aiysha" <amubarik@microstrategy.com> 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