more additions to cater to postgreSQL syntax