Path

ez components / documentation / api reference / 1.0 / database

eZ Components 1.0

Database: ezcQueryExpressionPgsql

[ Tutorial ] [ Class tree ] [ Element index ] [ ChangeLog ] [ Credits ]

Class: ezcQueryExpressionPgsql

The ezcQueryExpressionPgsql class is used to create SQL expression for PostgreSQL. [source]
This class reimplements the methods that have a different syntax in postgreSQL.

Parents

ezcQueryExpression
   |
   --ezcQueryExpressionPgsql

Method Summary

public ezcQueryExpressionPgsql __construct( $version )
Constructs an empty ezcQueryExpression with the versoin $version.
public string concat( 0 )
Returns a series of strings concatinated
public string md5( $column )
Returns the md5 sum of a field.
public string subString( $value, $from, [$len = null] )
Returns part of a string.

Inherited Methods

From ezcQueryExpression :
public ezcQueryExpression ezcQueryExpression::__construct()
Constructs an empty ezcQueryExpression
public string ezcQueryExpression::add()
Returns the SQL to add values or expressions together.
public string ezcQueryExpression::avg()
Returns the average value of a column
public string ezcQueryExpression::between()
Returns SQL that checks if an expression evaluates to a value between two values.
public void ezcQueryExpression::concat()
Returns a series of strings concatinated
public string ezcQueryExpression::count()
Returns the number of rows (without a NULL value) of a column
public string ezcQueryExpression::div()
Returns the SQL to divide values or expressions by eachother.
public string ezcQueryExpression::eq()
Returns the SQL to check if two values are equal.
protected string ezcQueryExpression::getIdentifier()
Returns the correct identifier for the alias $alias.
protected array(string) ezcQueryExpression::getIdentifiers()
Returns the correct identifiers for the aliases found in $aliases.
public string ezcQueryExpression::gt()
Returns the SQL to check if one value is greater than another value.
public string ezcQueryExpression::gte()
Returns the SQL to check if one value is greater than or equal to another value.
public bool ezcQueryExpression::hasAliases()
Returns true if this object has aliases.
public string ezcQueryExpression::in()
Returns the SQL to check if a value is one in a set of given values..
public string ezcQueryExpression::isNull()
Returns SQL that checks if a expression is null.
public string ezcQueryExpression::lAnd()
Returns the SQL to bind logical expressions together using a logical and.
public string ezcQueryExpression::length()
Returns the length of a text field.
public void ezcQueryExpression::like()
Match a partial string in a column.
public string ezcQueryExpression::lOr()
Returns the SQL to bind logical expressions together using a logical or.
public string ezcQueryExpression::lt()
Returns the SQL to check if one value is less than another value.
public string ezcQueryExpression::lte()
Returns the SQL to check if one value is less than or equal to another value.
public string ezcQueryExpression::max()
Returns the highest value of a column
public string ezcQueryExpression::md5()
Returns the md5 sum of a field.
public string ezcQueryExpression::min()
Returns the lowest value of a column
public string ezcQueryExpression::mod()
Returns the remainder of the division operation $expression1 / $expression2.
public string ezcQueryExpression::mul()
Returns the SQL to multiply values or expressions by eachother.
public string ezcQueryExpression::neq()
Returns the SQL to check if two values are unequal.
public string ezcQueryExpression::not()
Returns the SQL for a logical not.
public string ezcQueryExpression::now()
Returns the current system date.
public string ezcQueryExpression::round()
Rounds a numeric field to the number of decimals specified.
public void ezcQueryExpression::setAliases()
Sets the aliases $aliases for this object.
public string ezcQueryExpression::sub()
Returns the SQL to subtract values or expressions from eachother.
public string ezcQueryExpression::subString()
Returns part of a string.
public string ezcQueryExpression::sum()
Returns the total sum of a column

Methods

__construct

ezcQueryExpressionPgsql __construct( int $version )
Constructs an empty ezcQueryExpression with the versoin $version.

Parameters

Name Type Description
$version int  

Redefinition of

Method Description
ezcQueryExpression::__construct() Constructs an empty ezcQueryExpression

concat

string concat( string|array(string) 0 )
Returns a series of strings concatinated
concat() accepts an arbitrary number of parameters. Each parameter must contain an expression or an array with expressions.

Parameters

Name Type Description
0 string|array(string) strings that will be concatinated.

Throws

ClassDescription
ezcQueryVariableParameterException if no parameters are provided.

Redefinition of

Method Description
ezcQueryExpression::concat() Returns a series of strings concatinated

md5

string md5( $column )
Returns the md5 sum of a field.
Note: Not SQL92, but common functionality
md5() works with the default PostgreSQL 8 versions.
If you are using PostgreSQL 7.x or older you need to make sure that the digest procedure. If you use RPMS (Redhat and Mandrake) install the postgresql-contrib package. You must then install the procedure by running this shell command: 
1.  psql [dbname] < /usr/share/pgsql/contrib/pgcrypto.sql
You should make sure you run this as the postgres user.

Parameters

Name Type Description
$column  

Redefinition of

Method Description
ezcQueryExpression::md5() Returns the md5 sum of a field.

subString

string subString( string $value, int $from, [int $len = null] )
Returns part of a string.
Note: Not SQL92, but common functionality.

Parameters

Name Type Description
$value string the target $value the string or the string column.
$from int extract from this characeter.
$len int extract this amount of characters.

Redefinition of

Method Description
ezcQueryExpression::subString() Returns part of a string.

Last updated: Thu, 31 Jan 2008