spi_getbinval(3) [centos man page]

SPI_GETBINVAL(3)					  PostgreSQL 9.2.7 Documentation					  SPI_GETBINVAL(3)

NAME

       SPI_getbinval - return the binary value of the specified column

SYNOPSIS

       Datum SPI_getbinval(HeapTuple row, TupleDesc rowdesc, int colnumber,
			   bool * isnull)

DESCRIPTION

       SPI_getbinval returns the value of the specified column in the internal form (as type Datum).

       This function does not allocate new space for the datum. In the case of a pass-by-reference data type, the return value will be a pointer
       into the passed row.

ARGUMENTS

       HeapTuple row
	   input row to be examined

       TupleDesc rowdesc
	   input row description

       int colnumber
	   column number (count starts at 1)

       bool * isnull
	   flag for a null value in the column

RETURN VALUE

       The binary value of the column is returned. The variable pointed to by isnull is set to true if the column is null, else to false.

       SPI_result is set to SPI_ERROR_NOATTRIBUTE on error.

PostgreSQL 9.2.7						    2014-02-17							  SPI_GETBINVAL(3)

PDOSTATEMENT.FETCHCOLUMN(3)						 1					       PDOSTATEMENT.FETCHCOLUMN(3)

PDOStatement::fetchColumn - Returns a single column from the next row of a result set

SYNOPSIS

       public mixed PDOStatement::fetchColumn ([int  $column_number])

DESCRIPTION

	Returns a single column from the next row of a result set or FALSE if there are no more rows.

       Note

	      PDOStatement.fetchColumn(3) should not be used to retrieve boolean columns, as it is impossible to distinguish a value of FALSE from
	      there being no more rows to retrieve. Use PDOStatement.fetch(3) instead.

PARAMETERS

	      o $column_number
		- 0-indexed number of the column you wish to retrieve from the row. If no value is supplied,  PDOStatement.fetchColumn(3)  fetches
		the first column.

RETURN VALUES

       PDOStatement.fetchColumn(3) returns a single column in the next row of a result set.

       Warning

	       There is no way to return another column from the same row if you use PDOStatement.fetchColumn(3) to retrieve data.

EXAMPLES

       Example #1

	      Return first column of the next row

	      <?php
	      $sth = $dbh->prepare("SELECT name, colour FROM fruit");
	      $sth->execute();

	      print("Fetch the first column from the first row in the result set:
");
	      $result = $sth->fetchColumn();
	      print("name = $result
");

	      print("Fetch the second column from the second row in the result set:
");
	      $result = $sth->fetchColumn(1);
	      print("colour = $result
");
	      ?>

	      The above example will output:

	      Fetch the first column from the first row in the result set:
	      name = lemon
	      Fetch the second column from the second row in the result set:
	      colour = red

SEE ALSO

       PDO.query(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDO.prepare(3), PDOStatement.setFetchMode(3).

PHP Documentation Group 											       PDOSTATEMENT.FETCHCOLUMN(3)