Ihor Romanchenko questions

Ihor Romanchenko answers

• Group by repeating attribute
• Compare postgresql enum in a function
• Not Able to Trigger the Exception NO_DATA_FOUND in postgreSQL
• Prepared statement with date added by interval as parameter in Postgresql
• PostgreSQL add id column that increments based on data
• Query to see if records start_date and end_date fall in between date range
• Any case where using an array type for table columns is really appropriate? [closed]
• Restoring postgres sql file over 20gb
• postgresql :: retrieve row matching exact condition or number of rows matching part of condition
• PostgreSQL manualy change query execution plan to force using sort and sequential access instead of full scan