Search Postgresql Archives

tablesample clause doesnt support to be applied to subquery.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux