MDB2_Driver_Function_pgsql Class Reference

Inheritance diagram for MDB2_Driver_Function_pgsql:

Collaboration diagram for MDB2_Driver_Function_pgsql:

Public Member Functions
&	executeStoredProc ($name, $params=null, $types=null, $result_class=true, $result_wrap_class=false)
	Execute a stored procedure and return any results. More...
	random ()
	return string to call a function to get random value inside an SQL statement More...
Public Member Functions inherited from MDB2_Driver_Function_Common
&	executeStoredProc ($name, $params=null, $types=null, $result_class=true, $result_wrap_class=false)
	Execute a stored procedure and return any results. More...
	functionTable ()
	return string for internal table used when calling only a function More...
	now ($type='timestamp')
	Return string to call a variable with the current timestamp inside an SQL statement There are three special variables for current date and time: More...
	substring ($value, $position=1, $length=null)
	return string to call a function to get a substring inside an SQL statement More...
	concat ($value1, $value2)
	Returns string to concatenate two or more string parameters. More...
	random ()
	return string to call a function to get random value inside an SQL statement More...
	lower ($expression)
	return string to call a function to lower the case of an expression More...
	upper ($expression)
	return string to call a function to upper the case of an expression More...
	guid ()
	Returns global unique identifier. More...
Public Member Functions inherited from MDB2_Module_Common
	__construct ($db_index)
	Constructor. More...
	MDB2_Module_Common ($db_index)
	PHP 4 Constructor. More...
&	getDBInstance ()
	Get the instance of MDB2 associated with the module instance. More...

Additional Inherited Members
Data Fields inherited from MDB2_Module_Common
	$db_index

Detailed Description

Definition at line 56 of file pgsql.php.

Member Function Documentation

executeStoredProc()

& MDB2_Driver_Function_pgsql::executeStoredProc	(		$name,
			$params = null,
			$types = null,
			$result_class = true,
			$result_wrap_class = false
	)

Execute a stored procedure and return any results.

Parameters

string	$name	string that identifies the function to execute
mixed	$params	array that contains the paramaters to pass the stored proc
mixed	$types	array that contains the types of the columns in the result set
mixed	$result_class	string which specifies which result class to use
mixed	$result_wrap_class	string which specifies which class to wrap results in

Returns

mixed a result handle or MDB2_OK on success, a MDB2 error on failure public

Definition at line 72 of file pgsql.php.

References $params, $query, MDB2_Module_Common\getDBInstance(), and PEAR\isError().

    {
        $db =& $this->getDBInstance();
        if (PEAR::isError($db)) {
            return $db;
        }

        $query = 'SELECT * FROM '.$name;
        $query .= $params ? '('.implode(', ', $params).')' : '()';
        return $db->query($query, $types, $result_class, $result_wrap_class);
    }

Here is the call graph for this function:

random()

MDB2_Driver_Function_pgsql::random

(

)

return string to call a function to get random value inside an SQL statement

Returns

return string to generate float between 0 and 1 public

Definition at line 92 of file pgsql.php.

    {
        return 'RANDOM()';
    }

---

The documentation for this class was generated from the following file:

• Services/Database/lib/PEAR/MDB2/Driver/Function/pgsql.php