Follow MacLochlainns Weblog on Feedspot

Continue with Google
Continue with Facebook

MacLochlainns Weblog
This is the blog of Michael McLaughlin, a veteran of Oracle technology si..
This shows how to write a PL/pgSQL function that returns a filtered table result set while writing to a debug log file. The example ..read more
The following two sample programs are used in an Python programming course that I teach. I find them useful in qualifying how to work with ..read more
I put this together to show my students how to simplify writing and testing Python library files. The trick requires that you learn how to ..read more
MacLochlainns Weblog by Maclochlainn - 1M ago
Somebody wanted a quick example of using a user-defined header file for a constant value. While I think there a lot of examples on the ..read more
In the process of working through issues to support ETL transformations from JSON with Python. The first step was extracting a the data ..read more
The process of creating a schema requires you grant the CREATE ON DATABASE privilege to the user as the postgres user. You use the ..read more
This demonstrates how you insert results from a common table expression (CTE) in a leading WITH clause. I thought it would be a nice add ..read more
Nine years after writing how to use the MERGE statement in Oracle, I am writing how you implement an UPSERT statement in PostgreSQL. I ..read more
Oracle and SQL Server use the MERGE statement, MySQL uses the REPLACE INTO statement or ON DUPLICATE KEY, but PostgreSQL uses an upsert. ..read more
MacLochlainns Weblog by Maclochlainn - 3M ago
I’m working on items for migrating my database class from Oracle to PostgreSQL. I ran into an interesting limitation when I tried using ..read more

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview