postgres/stmt

src/postgres/stmt.tur

defn

stmt-prepare

(stmt-prepare [^borrow conn : Conn name : cstr sql : cstr nparams : int] :)

defn

(stmt-exec-prepared [^borrow conn : Conn name : cstr params : int] :)

defn

(stmt-deallocate [^borrow conn : Conn name : cstr] :)

drop a named prepared statement from the server.

Parameters

conn		connection handle
name		name used in stmt-prepare

Returns

(Result int int) -- ok carries 0; err carries 0 on failure.

Example

(stmt-deallocate conn "insert-user")

Since: PG2

Internal definitions

__params-count-- count the number of cells in a cons list.

__params-values-- build a heap-allocated char** from a cons list of :cstr.

__dealloc-sql-- build "DEALLOCATE name" as a heap-allocated cstr.

__pq-prepare-raw-- PQprepare; returns 1 on success, 0 on failure.

__pq-exec-raw-- execute SQL with no params; returns 1 on success, 0 on failure.

__stmt-result-of-rc-- compile a named prepared statement on the server.

__pq-exec-prepared-typed-- execute a previously prepared statement with parameters.