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

hus787@gmail.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs