On Fri, Apr 4, 2025 at 11:55 AM Marcos Pegoraro <marcos@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
exponentialnotation 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
