tablesample clause doesnt support to be applied to subquery. - Mailing list pgsql-general

From Wind
Subject tablesample clause doesnt support to be applied to subquery.
Date
Msg-id 6c33bee6.2d89.1827c70b59a.Coremail.guolipengyeah@126.com
Whole thread Raw
Responses Re: tablesample clause doesnt support to be applied to subquery.
List 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?

pgsql-general by date:

Previous
From: Aleš Zelený
Date:
Subject: Re: PostgreSQL 14.4 ERROR: out of memory issues
Next
From: rob stone
Date:
Subject: Re: tablesample clause doesnt support to be applied to subquery.