spi_cursor_open_with_paramlist(3) [centos man page]
SPI_CURSOR_OPEN_WITH_PARAMLIST(3) PostgreSQL 9.2.7 Documentation SPI_CURSOR_OPEN_WITH_PARAMLIST(3)NAME
SPI_cursor_open_with_paramlist - set up a cursor using parameters
SYNOPSIS
Portal SPI_cursor_open_with_paramlist(const char *name,
SPIPlanPtr plan,
ParamListInfo params,
bool read_only)
DESCRIPTION
SPI_cursor_open_with_paramlist sets up a cursor (internally, a portal) that will execute a statement prepared by SPI_prepare. This function
is equivalent to SPI_cursor_open except that information about the parameter values to be passed to the query is presented differently. The
ParamListInfo representation can be convenient for passing down values that are already available in that format. It also supports use of
dynamic parameter sets via hook functions specified in ParamListInfo.
The passed-in parameter data will be copied into the cursor's portal, so it can be freed while the cursor still exists.
ARGUMENTS
const char * name
name for portal, or NULL to let the system select a name
SPIPlanPtr plan
prepared statement (returned by SPI_prepare)
ParamListInfo params
data structure containing parameter types and values; NULL if none
bool read_only
true for read-only execution
RETURN VALUE
Pointer to portal containing the cursor. Note there is no error return convention; any error will be reported via elog.
PostgreSQL 9.2.7 2014-02-17 SPI_CURSOR_OPEN_WITH_PARAMLIST(3)
Check Out this Related Man Page
SPI_CURSOR_OPEN(3) PostgreSQL 9.2.7 Documentation SPI_CURSOR_OPEN(3)NAME
SPI_cursor_open - set up a cursor using a statement created with SPI_prepare
SYNOPSIS
Portal SPI_cursor_open(const char * name, SPIPlanPtr plan,
Datum * values, const char * nulls,
bool read_only)
DESCRIPTION
SPI_cursor_open sets up a cursor (internally, a portal) that will execute a statement prepared by SPI_prepare. The parameters have the same
meanings as the corresponding parameters to SPI_execute_plan.
Using a cursor instead of executing the statement directly has two benefits. First, the result rows can be retrieved a few at a time,
avoiding memory overrun for queries that return many rows. Second, a portal can outlive the current procedure (it can, in fact, live to the
end of the current transaction). Returning the portal name to the procedure's caller provides a way of returning a row set as result.
The passed-in parameter data will be copied into the cursor's portal, so it can be freed while the cursor still exists.
ARGUMENTS
const char * name
name for portal, or NULL to let the system select a name
SPIPlanPtr plan
prepared statement (returned by SPI_prepare)
Datum * values
An array of actual parameter values. Must have same length as the statement's number of arguments.
const char * nulls
An array describing which parameters are null. Must have same length as the statement's number of arguments. n indicates a null value
(entry in values will be ignored); a space indicates a nonnull value (entry in values is valid).
If nulls is NULL then SPI_cursor_open assumes that no parameters are null.
bool read_only
true for read-only execution
RETURN VALUE
Pointer to portal containing the cursor. Note there is no error return convention; any error will be reported via elog.
PostgreSQL 9.2.7 2014-02-17 SPI_CURSOR_OPEN(3)
Hi friends,
I am using win32::ieautomation to automate portal
Please help me with below line of code:
my $target_cell = $table_object->tableCells(2, 5);
what is $table_object in above line
I am using $browser->getTable('id:', "table_id")->tableCells(2,5);
The error I get is can't... (0 Replies)
i am trying to develop a portal kind of thing where all the scripts will reside in unix.in our company we areusing Solaris.My requirement is to develop a portal which can be accessed from any where inside the oragnisation.If some one types a address 3.256.63.56/xxx.html the page should open.There... (0 Replies)
Hi,
I have a file ( all_users.ldif ) of the following format:
cn=orcladmin, cn=Users, dc=maximus,dc=com
cn=PUBLIC, cn=Users, dc=maximus,dc=com
cn=portal,cn=users,dc=maximus,dc=com
cn=portal_admin,cn=users,dc=maximus,dc=com
cn=uddi_publisher,cn=Users,dc=maximus,dc=com... (4 Replies)
Hi Guys,
In the following line:
cn=portal.090710.191533.428571000,cn=groups,dc=mp,dc=rj,dc=gov,dc=br
I need to extract this string: portal.090710.191533.428571000
As you can see this string always will be bettween "cn=" and "," strings.
Someone know one regular expression to... (4 Replies)
Very new to this.....
What I would like to do:
Create a simple GUI/Web portal with 3 buttons and 1 text field
The three buttons need to take the input into the text field and use that as the variable to execute scripts located on a server
Problem:
How can i get the buttons on the... (3 Replies)
Hello,
We have a script, when executed it asks for ( it searches servername is portal inventory )
Username
Password
Once's you provide that - if your server name is present in the portal it returns
O/p
PASS Gold correctly registered
My Query is based on above o/p
i want to... (7 Replies)