aboutsummaryrefslogtreecommitdiff
path: root/content/posts/2021-11-05-postgres-query-rewrite.md
diff options
context:
space:
mode:
Diffstat (limited to 'content/posts/2021-11-05-postgres-query-rewrite.md')
-rw-r--r--content/posts/2021-11-05-postgres-query-rewrite.md10
1 files changed, 5 insertions, 5 deletions
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.