Class PgSQLAssembler

Cross\DB\SQLAssembler\SQLAssembler

Extended by

Cross\DB\SQLAssembler\PgSQLAssembler

Namespace: Cross\DB\SQLAssembler
Package: Cross\DB\SQLAssembler
Author:

wonli wonli@live.com Class PgSQLAssembler

Located at DB/SQLAssembler/PgSQLAssembler.php

Methods summary

`public mixed\|`	# `find( string $table, string $fields, string $where, integer $order = 1, array & $page = array('p' => 1, 'limit' => 50), integer\|string $group_by = 1 )` 带分页功能的查询带分页功能的查询 Parameters `$table` 联合查询$table变量 $table = table_a a LEFT JOIN table_b b ON a.id=b.aid; `$fields` 要查询的字段所有字段的时候 $fields='*' `$where` 查询条件 `$order` 排序 `$page` 分页参数默认返回50条记录 `$group_by` Returns mixed\| Throws `Cross\Exception\CoreException` Overrides `Cross\DB\SQLAssembler\SQLAssembler::find`
`public string`	# `limit( integer $start, boolean\|integer $end = false )` PgSQL的limit如果有第二个参数, 那么和mysql的limit行为保持一致, 并且offset()不生效 PgSQL的limit如果有第二个参数, 那么和mysql的limit行为保持一致, 并且offset()不生效 Parameters `$start` `$end` Returns string Overrides `Cross\DB\SQLAssembler\SQLAssembler::limit`

Methods inherited from Cross\DB\SQLAssembler\SQLAssembler

__construct(), add(), del(), from(), getParams(), getPrefix(), getSQL(), groupBy(), having(), insert(), into(), offset(), on(), orderBy(), parseCondition(), parseFields(), parseGroup(), parseOrder(), parseWhere(), procedure(), replace(), select(), set(), setParams(), setSQL(), update(), where()

Properties summary

Properties inherited from Cross\DB\SQLAssembler\SQLAssembler

$offset_is_valid, $params, $sql, $table_prefix