Roman Pekar

Roman Pekar has asked 13 questions and find answers to 466 problems.

Stats

About

Constant battle for concise and elegant solutions.

ormeugensson at gmail.com

Roman Pekar questions

refer to value of unnest (or other srf) in WHERE
Unique filtered index and indexed view are ignored by optimizer
Avoiding "An INSERT EXEC statement cannot be nested"
Merge with Unique filtered index
Pandas remove column by index
Efficient way of storing date ranges
SQL: do we need ANY/SOME and ALL keywords?
Is there any reason why min and max not working on bit fields
Conditional UNION ALL in table function
How to get column-level dependencies in a view

Roman Pekar answers

Rolling KPI calculations in polars, index not visible
Return two nearest / closest rows above and below a target value in Polars
Postgresql trigger funciton seems to prevent insertion of any record
Generic select doesn't work with bit type
count the tuples of a pandas Dataframe
SQL Subquery returned more than 1 value
Use polars when-then-otherwise on multiple output columns at once
How to achieve Polars' previous `pivot()` functionality pre 0.20.7?
Error in postgres Cursor
SQL: SUM after GROUP BY