News for hackers. Stuff that matters.

A comment on Tell HN: Citus is 100% open source now. Parent comment

Re:Tell HN: Citus is 100% open source now by quickthrower2 on Friday September 02, 2022 @02:25PM (#32694157)
SELECT is a bit like return?

return 6;

or

return x++;

or even

return (exit(0));

[ Parent | on HN ]
Re:Tell HN: Citus is 100% open source now by colejohnson66 on Friday September 02, 2022 @02:28PM (#32694184)
I think GP is saying they view SELECT as a "pure" function. A pure function doesn't modify state, so neither should SELECT.
[ Parent | on HN ]
Re:Tell HN: Citus is 100% open source now by bombcar on Friday September 02, 2022 @02:33PM (#32694248)
Yeah, from limited experience with SQL "SELECT is safe" (assuming no weirdness in sub functions or commands) but that's clearly not always the case.
[ Parent | on HN ]