Em sex., 4 de abr. de 2025 às 13:13, Maciek Sakrejda
escreveu:
> maciek=# select pg_typeof(1e1)
Correct, this explains that
regards
Marcos
Robert Haas writes:
> 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 1 are of different
> data types, which seems likely to be relevant somehow.
I am
On Fri, Apr 4, 2025 at 11:55 AM Marcos Pegoraro 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)/1 from (
> select * from generate_series(15e2,65e5) wit
I took a look at simplifying this test case, and I think it comes down
to data types:
maciek=# select 9/10;
?column?
--
0
(1 row)
maciek=# select pg_typeof(10);
pg_typeof
---
integer
(1 row)
But:
maciek=# select 9/1e1;
?column?
0.9000
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)/1 from (
select * from generate_series(15e2,65e5) with ordinality) x(ID, ord) group
by 2 order by 2;
But it's easier to
