On Fri, Apr 4, 2025 at 11:55 AM Marcos Pegoraro <mar...@f10.com.br> wrote:
> I was deleting thousands of records each time with \gexec, then ...
>
> This one works
> select format('delete from table where ID = any(%L::integer[]);',
> array_agg(ID)), (ord-1)/10000 from (
> select * from generate_series(15e2,65e5) with ordinality) x(ID, ord) group by
> 2 order by 2;
>
> But it's easier to write in exponential notation, so I changed this
> (ord-1)/10000 to (ord-1)/1e4. Using this way exponential notation is just
> ignored.
This seems like a question for -general or some other user-focused
mailing list, not hackers. At any rate, I don't see how 1e4 could just
be "ignored", but as Maciek points out, 1e4 and 10000 are of different
data types, which seems likely to be relevant somehow.
--
Robert Haas
EDB: http://www.enterprisedb.com
