News for hackers. Stuff that matters.

A comment on Null Values in SQL Queries. Parent comment

Re:Null Values in SQL Queries by gnosek on Tuesday February 04, 2020 @02:22AM (#22233217)
Not sure how this integrates with Go's database drivers but from the Postgres side:

1. NULLIF(the_uuid, '0000-000000-00000-0000')

https://www.postgresql.org/docs/current/functions-conditiona...

2. on insert/update rules to rewrite the uuid (probably using NULLIF)

https://www.postgresql.org/docs/current/sql-createrule.html

[ Parent | on HN ]

There are no comments on this comment yet.