Re: Error when rewriting a query into multiple queries

2021-11-21 Thread David G. Johnston
On Friday, November 19, 2021, Huang Wang wrote: > Is there any way to do it on the server or it's better to do it in the > application? > Application; and for me at least modifying the server to do this is an extremely bad idea that goes against its fundamental design. David J.

Error when rewriting a query into multiple queries

2021-11-21 Thread Huang Wang
Dear Sir or Madam, I'm trying to add progressive query into Postgres. Assume a query 'SELECT * FROM hugetable', my idea is to rewrite it into several queries as 'SELECT * FROM hugetable TABLESAMPLE SYSTEM_TIME(500)' 'SELECT * FROM hugetable TABLESAMPLE SYSTEM_TIME(1000)' 'SELECT * FROM