tablesample clause doesnt support to be applied to subquery.

From: Wind <guolipengyeah(at)126(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: tablesample clause doesnt support to be applied to subquery.
Date: 2022-08-08 07:52:17
Message-ID: 6c33bee6.2d89.1827c70b59a.Coremail.guolipengyeah@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi~
I test "tablesample" feature on pg9.5 and found that tablesample doesnt support to be applied to subquery.
for example this sql doesnt work on pg9.5:
```
create table t1(
c1 int,
c2 int
);
select c2 from (select * from t1) as t2 tablesample system (50);
```
while i read sql2003 standard about tablesample and think it should allow this usage according to standard.
is it a deviation to sql standard?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2022-08-08 08:05:51 Re: tablesample clause doesnt support to be applied to subquery.
Previous Message Aleš Zelený 2022-08-07 19:47:09 Re: PostgreSQL 14.4 ERROR: out of memory issues