News for hackers. Stuff that matters.

A comment on Show HN: PRQL in PostgreSQL. Parent comment

Re:Show HN: PRQL in PostgreSQL by jpgvm on Monday February 19, 2024 @04:42PM (#39435169)
Details in sibling but I dug a bit deeper, new version used to_char, turns out that is STABLE and not IMMUTABLE so because the volatility didn't match the whole way down anymore it broke inlining.

I'm guessing switching the function that calls to_char to STABLE will fix the problem.

[ Parent | on HN ]
Re:Show HN: PRQL in PostgreSQL by zeroimpl on Monday February 19, 2024 @05:03PM (#39435372)
Makes sense. You mentioned index so I thought maybe you were were querying a table.

Would be nice if postgresql could tell you when the flags don’t match. I think anytime you deal with timestamps you can have problems since the expression may depend on the session’s time zone.

[ Parent | on HN ]