Обсуждение: Let us fix the documentation
The following url seems to be slightly incorrect: http://www.postgresql.org/docs/9.3/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); I guess the first line of the example should be: PREPARE usrrptplan (int, date) AS What do you think? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Let-us-fix-the-documentation-tp5782999.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
On Wed, December 11, 2013 22:51, AK wrote: > The following url seems to be slightly incorrect: > > http://www.postgresql.org/docs/9.3/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); > > I guess the first line of the example should be: > > PREPARE usrrptplan (int, date) AS > > What do you think? > read the next line: "Note that the data type of the second parameter is not specified, so it is inferred from the context in which $2 is used." (So the example is correct as is)
Oops, did not notice that - thank you! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Let-us-fix-the-documentation-tp5782999p5783002.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.