Roman Pekar

Roman Pekar has asked 14 questions and find answers to 492 problems.

Stats

About

Constant battle for concise and elegant solutions.

ormeugensson at gmail.com

Roman Pekar questions

Is it possible to check if the column exists in the table in another database, dynamically
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

Roman Pekar answers

Python - Lambda function on multiple columns
Nested looping over tuple values in a dictionary with tuple keys python
XML parsing: line 1, character 7, semicolon expected
Delete multiple rows in PostgreSQL with Entity Framework using WHERE IN clause
Merge or flatten list of lists in Polars
Postgres: Could not identify an ordering operator for type unknown
Explode a polars DataFrame column without duplicating other column values
PostgreSQL: Get last updates by joining 2 tables
How to get the value of a specified index number from the sorting of a column and fill it with null if missing?
Duplicating a record with different ID