joanolo questions

joanolo answers

• Postgres aggregate results based on 2 columns
• Slow regex query on 80M record in PostgreSQL
• Producing date from year and month values in PostgreSQL
• SQL join arbitrary information to form a mixed list
• MySQL calculate time difference between multiple rows based on status field
• Database structure and queries for a Twitter-like posts timeline
• Can a View of multiple tables be used for Full-Text-Search?
• Insert POINT into postgres database
• Populate random data from another table
• PostgreSQL - Right Index choice for a status field (varchar)