Обсуждение: BUG #14104: PREPARE document has a missing parameter in one of the examples

Поиск
Список
Период
Сортировка

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

От
hus787@gmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      14104
Logged by:          Hussain Parsaiyan
Email address:      hus787@gmail.com
PostgreSQL version: 9.5.2
Operating system:   MacOSX
Description:

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.

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

От
Tom Lane
Дата:
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