A simple PL/pgSQL function to round either a datetime or timestamp value to the nearest N seconds.
Archive | PostgreSQL RSS feed for this section
Base36 Conversion in PostgreSQL
Using PostgreSQL to base36 encode (and decode) large integers for better human readability. Base36 encoding intermixes letters and digits and is most frequently encountered with URL shortening services and on Dell service tags.
A Basic Introduction to Postgres Stored Procedures
This article introduces the very basics of writing stored procedures with PostgreSQL (aka Postgres), an open-source database system. It is intended for both Postgres newbies and MS SQL Server/MySQL stored procedure veterans who are interested learning more about Postgres.
Introduction
I originally come from the world of MS SQL Server where stored procedures (“sprocs”) were a fact [...]
Latest Comments