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

From rob stone
Subject Re: tablesample clause doesnt support to be applied to subquery.
Date
Msg-id a462479f1c852a8c3af4d4072bd3b219784281d6.camel@tpg.com.au
Whole thread Raw
In response to tablesample clause doesnt support to be applied to subquery.  (Wind <guolipengyeah@126.com>)
List pgsql-general
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,




pgsql-general by date:

Previous
From: Wind
Date:
Subject: tablesample clause doesnt support to be applied to subquery.
Next
From: "Techsupport"
Date:
Subject: RE: 20220722-pg_dump: error: invalid number of parents 0 for table