dave questions

dave answers

• Postgresql UNION takes 10 times as long as running the individual queries
• List only certain files in a directory matching the word BOZO and ending with either '123' or '456'
• Pivoting rows into columns dynamically in Oracle
• ADD time 23:59:59.999 to end date for between