pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Tablesample Function on Postgres 9.1
4+ messages / 3 participants
[nested] [flat]

* Tablesample Function on Postgres 9.1
@ 2012-08-29 19:48 Mubarik, Aiysha <amubarik@microstrategy.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Mubarik, Aiysha @ 2012-08-29 19:48 UTC (permalink / raw)
  To: pgsql-sql

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 seems like tablesample is supported (https://wiki.postgresql.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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Tablesample Function on Postgres 9.1
@ 2012-08-29 19:52 Mubarik, Aiysha <amubarik@microstrategy.com>
  2012-08-29 20:07 ` Re: Tablesample Function on Postgres 9.1 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Mubarik, Aiysha @ 2012-08-29 19:52 UTC (permalink / raw)
  To: pgsql-sql

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 seems like tablesample is supported (https://wiki.postgresql.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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Tablesample Function on Postgres 9.1
  2012-08-29 19:52 Tablesample Function on Postgres 9.1 Mubarik, Aiysha <amubarik@microstrategy.com>
@ 2012-08-29 20:07 ` Tom Lane <tgl@sss.pgh.pa.us>
  2012-08-30 02:20   ` Re: Tablesample Function on Postgres 9.1 Craig Ringer <ringerc@ringerc.id.au>
  0 siblings, 1 reply; 4+ messages in thread

From: Tom Lane @ 2012-08-29 20:07 UTC (permalink / raw)
  To: Mubarik, Aiysha <amubarik@microstrategy.com>; +Cc: pgsql-sql

"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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Tablesample Function on Postgres 9.1
  2012-08-29 19:52 Tablesample Function on Postgres 9.1 Mubarik, Aiysha <amubarik@microstrategy.com>
  2012-08-29 20:07 ` Re: Tablesample Function on Postgres 9.1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2012-08-30 02:20   ` Craig Ringer <ringerc@ringerc.id.au>
  0 siblings, 0 replies; 4+ messages in thread

From: Craig Ringer @ 2012-08-30 02:20 UTC (permalink / raw)
  To: ; +Cc: Mubarik, Aiysha <amubarik@microstrategy.com>; pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2012-08-30 02:20 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-08-29 19:48 Tablesample Function on Postgres 9.1 Mubarik, Aiysha <amubarik@microstrategy.com>
2012-08-29 19:52 Tablesample Function on Postgres 9.1 Mubarik, Aiysha <amubarik@microstrategy.com>
2012-08-29 20:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-08-30 02:20   ` Craig Ringer <ringerc@ringerc.id.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox