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) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers