PGParameters.add

Creates and returns new parameter.

class PGParameters
add
(
short index
,
PGType type
)

Examples

1 // without spaces between $ and number
2 auto cmd = new PGCommand(conn, "INSERT INTO users (name, surname) VALUES ($ 1, $ 2)");
3 cmd.parameters.add(1, PGType.TEXT).value = "John";
4 cmd.parameters.add(2, PGType.TEXT).value = "Doe";
5 
6 assert(cmd.executeNonQuery == 1);

Meta