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