Exponential notation bug

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Exponential notation bug
Date: 2025-04-04 15:55:08
Message-ID: CAB-JLwbfoHjq6u4ZKLUXDX9w8b1YaOKPn382dRiDiQAe8ftofQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards
Marcos

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-04-04 16:00:39 Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Previous Message Melanie Plageman 2025-04-04 15:47:10 Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate