On Thu, 30 Mar 2023 at 10:01, Dominique Devienne <ddevienne@gmail.com> wrote: > BTW, default and 0 are not the same thing. You cannot bind "default" in place of > an integer-valued prepared-statement placeholder, in a binary mode insert. So it is > definitely not the same thing.
IMNSHO if you need to select between default and explicit in an insert via binding you have a design problem, and down this path lies madness.
I fail to see that myself, sorry. You can bind NULL, you can bind values, so why
wouldn't you be able to bind DEFAULT too? I see that more as a failing to the
binding API myself :)
But I guess it can be worked around with something like
`... values(coalesce($1, default), ..)`
and abusing NULL to mean DEFAULT on a case-by-case bases.
Assuming default can be used in this way (didn't try), of course.
