logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

PQparamSendQuery, PQparamSendQueryPrepared - Executes an asynchronous paramertized query using the

Author

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

Description

       The PQparamSendQuery() and PQparamSendQueryPrepared()  functions  execute  an  asynchronous  paramertized
       query  using  the  parameters  in  a  PGparam.   The  only  difference  between  these  functions is that
       PQparamSendQuery() expects a parameterized command  string  while  PQparamSendQueryPrepared()  expects  a
       stmtName previously prepared via PQprepare().

       Both  functions  take  a  param  argument, which must contain the same number of parameters as either the
       command string or previously prepared stmtName.  Internally,  the  param  is  transformed  into  parallel
       arrays that are supplied to a PQsendQueryParams() or PQsendQueryPrepared() call.

       The  resultFormat  argument  indicates  if  text  or  binary  results are desired; a value of zero or one
       respectively.  PQgetf supports both text and binary result formats, with  the  exclusion  of  arrays  and
       composites which only support binary.

       After  successfully  calling PQparamSendQuery() or PQparamSendQueryPrepared(), call libpq´s PQgetResult()
       one or more times to obtain the results.

Examples

UsingPQparamSendQuery
       The example uses PQparamSendQuery() to execute a query using a PGparam.

              PGparam*param=PQparamCreate(conn);if(!PQputf(param,"%text%int4","ACTIVE",CAT_CAR)){fprintf(stderr,"PQputf:%s\n",PQgeterror());}else{intsuccess=PQparamSendQuery(conn,param,"SELECT*FROMtWHEREstatus=$1ANDcategory=$2",1);if(!success)fprintf(stderr,"PQparamSendQuery:%s\n",PQgeterror());elseget_and_print_results(conn);/*callsPQgetResult()*/}PQparamClear(param);UsingPQparamSendQueryPreparedPQparamSendQueryPrepared()      is      behaves     identically     to     PQparamSendQuery(),     except
       PQparamSendQueryPrepared() requires that a statement has been previously prepared via PQprepare().  Also,
       a stmtName is supplied rather than a parameterized command string.

Name

       PQparamSendQuery,  PQparamSendQueryPrepared  -  Executes  an  asynchronous  paramertized  query using the
       parameters in a PGparam.

Reporting Bugs

       Report bugs to <libpqtypes@esilo.com>.

Return Value

       On success, a non-zero value is returned.  On error, zero is returned and PQgeterror(3) will  contain  an
       error message.

See Also

PQparamCreate(3), PQgeterror(3), PQparamExec(3), PQparamExecPrepared(3)

libpqtypes                                            2011                                   PQparamSendQuery(3)

Synopsis

#include<libpqtypes.h>intPQparamSendQuery(PGconn*conn,PGparam*param,constchar*command,intresultFormat);intPQparamSendQueryPrepared(PGconn*conn,PGparam*param,constchar*stmtName,intresultFormat);

See Also