On Thu, Mar 30, 2023 at 11:42 AM Francisco Olarte <fola...@peoplecall.com> wrote:
> On Thu, 30 Mar 2023 at 10:01, Dominique Devienne <ddevie...@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.
