On Sunday, October 15, 2017, Eduardo Pérez Ureta <edpeur(at)gmail(dot)com> wrote:
> I understand that not sending the type for a parameter (when it is not
> null) may not make much sense.
> But, currently PostgreSQL accepts parameters with unknown types in
> statements like:
> INSERT INTO t1 (col1) VALUES (?)
> SELECT * FROM t1 WHERE col1 = ?
> where the column can be different types like VARCHAR or TIMESTAMP
>
col1 has a type and so the type of the unspecified variable can be
inferred. Your is null example cannot have its typed inferred.
David J.