Linux Manuals

dblink_get_notify – retrieve async notifications on a connection Synopsisdblink_get_notify() returns setof (notify_name text, be_pid int, extra text) dblink_get_notify(text connname) returns setof (notify_name text, be_pid int, extra text)Descriptiondblink_get_notify retrieves notifications on either the unnamed connection, or on a named connection if specified. To receive notifications via dblink, LISTEN must first be issued, using dblink_exec. For details…

dblink_get_connections – returns the names of all open named dblink connections Synopsisdblink_get_connections() returns text[]Descriptiondblink_get_connections returns an array of the names of all open named dblink connections. Return ValueReturns a text array of connection names, or NULL if none. ExamplesSELECT dblink_get_connections();

dblink_fetch – returns rows from an open cursor in a remote database Synopsisdblink_fetch(text cursorname, int howmany [, bool fail_on_error]) returns setof record dblink_fetch(text connname, text cursorname, int howmany [, bool fail_on_error]) returns setof recordDescriptiondblink_fetch fetches rows from a cursor previously established by dblink_open. Argumentsconnname Name of the connection to use; omit this parameter to use…

dblink_exec – executes a command in a remote database Synopsisdblink_exec(text connname, text sql [, bool fail_on_error]) returns text dblink_exec(text connstr, text sql [, bool fail_on_error]) returns text dblink_exec(text sql [, bool fail_on_error]) returns textDescriptiondblink_exec executes a command (that is, any SQL statement that doesn’t return rows) in a remote database. When two text arguments are…

dblink_error_message – gets last error message on the named connection Synopsisdblink_error_message(text connname) returns textDescriptiondblink_error_message fetches the most recent remote error message for a given connection. Argumentsconnname Name of the connection to use.Return ValueReturns last error message, or an empty string if there has been no error in this connection. ExamplesSELECT dblink_error_message(‘dtest1’);

dblink_disconnect – closes a persistent connection to a remote database Synopsisdblink_disconnect() returns text dblink_disconnect(text connname) returns textDescriptiondblink_disconnect() closes a connection previously opened by dblink_connect(). The form with no arguments closes an unnamed connection. Argumentsconnname The name of a named connection to be closed.Return ValueReturns status, which is always OK (since any error causes the function…

dblink_connect_u – opens a persistent connection to a remote database, insecurely Synopsisdblink_connect_u(text connstr) returns text dblink_connect_u(text connname, text connstr) returns textDescriptiondblink_connect_u() is identical to dblink_connect(), except that it will allow non-superusers to connect using any authentication method. If the remote server selects an authentication method that does not involve a password, then impersonation and subsequent…

dblink_connect – opens a persistent connection to a remote database Synopsisdblink_connect(text connstr) returns text dblink_connect(text connname, text connstr) returns textDescriptiondblink_connect() establishes a connection to a remote PostgreSQL database. The server and database to be contacted are identified through a standard libpq connection string. Optionally, a name can be assigned to the connection. Multiple named connections…

dblink_close – closes a cursor in a remote database Synopsisdblink_close(text cursorname [, bool fail_on_error]) returns text dblink_close(text connname, text cursorname [, bool fail_on_error]) returns textDescriptiondblink_close closes a cursor previously opened with dblink_open. Argumentsconnname Name of the connection to use; omit this parameter to use the unnamed connection. cursorname The name of the cursor to close….

dblink_cancel_query – cancels any active query on the named connection Synopsisdblink_cancel_query(text connname) returns textDescriptiondblink_cancel_query attempts to cancel any query that is in progress on the named connection. Note that this is not certain to succeed (since, for example, the remote query might already have finished). A cancel request simply improves the odds that the query…

dblink_build_sql_update – builds an UPDATE statement using a local tuple, replacing the primary key field values with alternative supplied values Synopsisdblink_build_sql_update(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] src_pk_att_vals_array, text[] tgt_pk_att_vals_array) returns textDescriptiondblink_build_sql_update can be useful in doing selective replication of a local table to a remote database. It selects a row from the local table…

dblink_build_sql_insert – builds an INSERT statement using a local tuple, replacing the primary key field values with alternative supplied values Synopsisdblink_build_sql_insert(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] src_pk_att_vals_array, text[] tgt_pk_att_vals_array) returns textDescriptiondblink_build_sql_insert can be useful in doing selective replication of a local table to a remote database. It selects a row from the local table…

dblink_build_sql_delete – builds a DELETE statement using supplied values for primary key field values Synopsisdblink_build_sql_delete(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] tgt_pk_att_vals_array) returns textDescriptiondblink_build_sql_delete can be useful in doing selective replication of a local table to a remote database. It builds a SQL DELETE command that will delete the row with the given primary key…

dblink – executes a query in a remote database Synopsisdblink(text connname, text sql [, bool fail_on_error]) returns setof record dblink(text connstr, text sql [, bool fail_on_error]) returns setof record dblink(text sql [, bool fail_on_error]) returns setof recordDescriptiondblink executes a query (usually a SELECT, but it can be any SQL statement that returns rows) in a…

dbdsqr.f – SynopsisFunctions/Subroutinessubroutine dbdsqr (UPLO, N, NCVT, NRU, NCC, D, E, VT, LDVT, U, LDU, C, LDC, WORK, INFO) DBDSQR Function/Subroutine Documentationsubroutine dbdsqr (characterUPLO, integerN, integerNCVT, integerNRU, integerNCC, double precision, dimension( * )D, double precision, dimension( * )E, double precision, dimension( ldvt, * )VT, integerLDVT, double precision, dimension( ldu, * )U, integerLDU, double precision, dimension(…

dbdsdc.f – SynopsisFunctions/Subroutinessubroutine dbdsdc (UPLO, COMPQ, N, D, E, U, LDU, VT, LDVT, Q, IQ, WORK, IWORK, INFO) DBDSDC Function/Subroutine Documentationsubroutine dbdsdc (characterUPLO, characterCOMPQ, integerN, double precision, dimension( * )D, double precision, dimension( * )E, double precision, dimension( ldu, * )U, integerLDU, double precision, dimension( ldvt, * )VT, integerLDVT, double precision, dimension( * )Q, integer,…

dbbcsd.f – SynopsisFunctions/Subroutinessubroutine dbbcsd (JOBU1, JOBU2, JOBV1T, JOBV2T, TRANS, M, P, Q, THETA, PHI, U1, LDU1, U2, LDU2, V1T, LDV1T, V2T, LDV2T, B11D, B11E, B12D, B12E, B21D, B21E, B22D, B22E, WORK, LWORK, INFO) DBBCSD Function/Subroutine Documentationsubroutine dbbcsd (characterJOBU1, characterJOBU2, characterJOBV1T, characterJOBV2T, characterTRANS, integerM, integerP, integerQ, double precision, dimension( * )THETA, double precision, dimension( * )PHI,…

dbopen – database access methods Synopsis#include <sys/types.h> #include <limits.h> #include <db.h> #include <fcntl.h> DB *dbopen(const char *file, int flags, int mode, DBTYPE type, const void *openinfo);DescriptionNote well: This page documents interfaces provided in glibc up until version 2.1. Since version 2.2, glibc no longer provides these interfaces. Probably, you are looking for the APIs provided…

QuantLib::GJRGARCHProcess – Stochastic-volatility GJR-GARCH(1,1) process. Synopsis#include <ql/processes/gjrgarchprocess.hpp> Inherits QuantLib::StochasticProcess. Public Typesenum Discretization { PartialTruncation, FullTruncation, Reflection } Public Member FunctionsGJRGARCHProcess (const Handle< YieldTermStructure > &riskFreeRate, const Handle< YieldTermStructure > &dividendYield, const Handle< Quote > &s0, Real v0, Real omega, Real alpha, Real beta, Real gamma, Real lambda, Real daysPerYear=252.0, Discretization d=FullTruncation) Size size () const…

QuantLib::Period – Synopsis#include <ql/time/period.hpp> Public Member FunctionsPeriod (Integer n, TimeUnit units) Period (Frequency f) Integer length () const TimeUnit units () const Frequency frequency () const Period & operator+= (const Period &) Period & operator-= (const Period &) Period & operator/= (Integer) void normalize () Related Functions(Note that these are not member functions.) Real years…