GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
PQparamCreate(3) libpqtypes Manual PQparamCreate(3)

PQparamCreate, PQparamCount PQparamReset, PQparamClear - PGparam management functions.

#include <libpqtypes.h>

PGparam *PQparamCreate(const PGconn *conn);
PGparam *PQparamDup(PGparam *param);
int PQparamCount(PGparam *param);
void PQparamReset(PGparam *param);
void PQparamClear(PGparam *param);

These functions manage the opaque PGparam object.

PQparamCreate() will allocate and initialize a new PGparam object. After the create call, the PGparam object is ready for use. WARNING: Only types that have been registered via PQregisterXXX, will be available to the param. Meaning, the param is not updated with types registered after the param is created.

PQparamDup() will duplicate a given PGparam, including any internal values that have already been put. This is useful in cases where you want to queue qeuries to execute at a later time, like a connection pooler. The problem is PGparamCreate requires a connection object, which may not be available when attempting to enqueue a query with its PGparam object. Instead, a PGparam object can used for the sole purpose of creating duplicates while there are no available PGconn objects.

PQparamCount() gets the number of parameters in a PGparam object.

PQparamReset() will clear out any previously put parameters, but will not free any memory. This is useful for application looking to "reuse" a PGparam object.

PQparamClear() releases all resources being used by a PGparam object, the object should not be used after a clear.

It is very important to call PQparamReset() if you plan on reusing a PGparam object.

PQparamCreate() returns a pointer to a PGparam object on success and NULL if something failed (check PQgeterror(3) for more information).

PQparamCount() returns the number of parameters in a PGparam object.

PQparamReset() and PQparamClear() have no return values. If either function is provided a NULL PGparam pointer, it will silently fail.

None.

A contribution of eSilo, LLC. for the PostgreSQL Database Management System. Written by Andrew Chernow and Merlin Moncure.

Report bugs to <libpqtypes@esilo.com>.

Copyright (c) 2011 eSilo, LLC. All rights reserved.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

pqt-specs(3), PQputf(3), PQgeterror(3), PQparamExec(3)
2011 libpqtypes

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.