Roman Pekar

Roman Pekar has asked 12 questions and find answers to 412 problems.

Stats

About

Constant battle for concise and elegant solutions.

ormeugensson at gmail.com

Roman Pekar questions

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

With Python Polars, how to compare two frame (like with `==`), but while returning True/False on comparisons with null
How to add a column with JSON representation of rows in Polars DataFrame?
Postgres ts_rank_cd: No function matches the given name and argument type
Divide every nth element of a Polars list with a number
Parsing strings with numbers and SI prefixes in polars
How to extract values based on column names and put it in another column in polars?
Can I get a histogram where each value is the sum instead of count of values in bucket?
Postgresql function return multiple rows
Rolling window of next rows in Polars
How to calculate mode when using python-polars in aggregation