Thread: 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
From
hus787@gmail.com
Date:
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.
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