Roman Pekar

Roman Pekar has asked 13 questions and find answers to 460 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

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
Polars `ValueError: could not convert value 'Unknown' as a Literal` when taking mean of function of variable
When to use the table operator APPLY
Update each cell in a polars dataframe using a dict of cell-value in parallel way?
Parent Child relation in SQL Server
Polars - groupby mean on list
Distinct elements across subgroups for each group in polars