hus787(at)gmail(dot)com writes:
> The second example here:
> http://www.postgresql.org/docs/9.4/static/sql-prepare.html
> ```
> PREPARE usrrptplan (int) AS
> SELECT * FROM users u, logs l WHERE u.usrid=$1 AND u.usrid=l.usrid
> AND l.date = $2;
> EXECUTE usrrptplan(1, current_date);
> ```
> `usrrptplan` should take in too arguments.
No, it's intentionally that way; the point of the example is to show
that you can let the parser infer the types of arguments if you like.
Note the subsequent para:
Note that the data type of the second parameter is not specified,
so it is inferred from the context in which $2 is used.
regards, tom lane