Re: BUG #14104: PREPARE document has a missing parameter in one of the examples

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