Ihor Romanchenko questions

Ihor Romanchenko answers

• PostgreSQL manualy change query execution plan to force using sort and sequential access instead of full scan
• Replacing regex matched text with uppercase version in Postgresql
• PostgreSQL subquery with syntax error gives a valid result
• Construct nested object graph from SQL hasmany relationship
• PostgreSQL cursor with arguments
• Optimize SELECT query with ORDER BY, OFFSET and LIMIT of postgresql
• Which postgres data type should I use for large XML message come from network?
• select from ... - based on a value in JSON format
• SQL sum of column value, unique per user per day
• can we select and update to database together?