This is not an SQL course, not even a crash-course, not a introduction, not a master class… It’s just a compilation of tips, tricks or unusual uses of PostgreSQL / PostGIS that I use a lot and may be helpful for anybody out there.
PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4 Example Let's look at some PostgreSQL trunc function examples and explore how to use the trunc function in PostgreSQL.
Write the queries for Data Definition (CREATE, DROP, ALTER and RENAME) and Data Manipulation Language (SELECT, INSERT, UPDATE and DELETE).
Get ROUND() in Postgresql: ROUND() function in posgresql gets the round off value. round off the value in postgresql - ROUND() Round off value to decimal places in postgresql Create the column which round off the value of the column With an example for each.