On Sunday, October 15, 2017, Eduardo Pérez Ureta <
edpeur@gmail.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.