Thread: tablesample clause doesnt support to be applied to subquery.
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?
Hello, On Mon, 2022-08-08 at 15:52 +0800, Wind wrote: > 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? Version 9.5 is not supported. The oldest supported version is 10, the current version is 14. Please read chapter 58 in the doco. HTH,