From 92787c159262a57fa20b2eb05ed710e1e6cfca96 Mon Sep 17 00:00:00 2001 From: Martin Ashby Date: Mon, 25 Mar 2024 21:36:21 +0000 Subject: Final conversion to Zine --- content/posts/2021-11-05-postgres-query-rewrite.md | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'content/posts/2021-11-05-postgres-query-rewrite.md') diff --git a/content/posts/2021-11-05-postgres-query-rewrite.md b/content/posts/2021-11-05-postgres-query-rewrite.md index a70323c..4a2959e 100644 --- a/content/posts/2021-11-05-postgres-query-rewrite.md +++ b/content/posts/2021-11-05-postgres-query-rewrite.md @@ -1,9 +1,9 @@ --- -title: "Postgres Query Rewrite" -date: 2021-11-05T11:57:12Z -draft: false -params: - comments: true +.title = "Postgres Query Rewrite", +.author = "Martin Ashby", +.date = @date("2021-11-05T11:57:12Z"), +.layout = "single.html", +.custom = {"comments": true}, --- Recently at work, I needed to be able to rewrite some [postgresql](https://www.postgresql.org/) queries which were coming from a closed-source application in order to integrate the app into our own system testing setup. Specifically I needed to replace instances of `current_timestamp` with invocation of `now()` function. -- cgit v1.2.3-ZIG