Matthew Wood questions

Matthew Wood answers

• Postgres Rails Select Distinct with Order
• Auto-reconnect in postgres with tomcat pool and Spring
• Ruby on Rails: How to set a database timeout in application configuration?
• psql --(record|field)-separator NUL
• Permissions required to allow arbitrary sql to be executed safely
• How to query just the last record of every day
• Running SQL script through psql gives syntax errors that don't occur in PgAdmin
• Postgres EXPLAIN ANALYZE is much faster than running the query normally
• Why the most natural query(I.e. using INNER JOIN (instead of LEFT JOIN)) is very slow
• correct way to create a pivot table in postgresql using CASE WHEN