Package

com.github.tminglei.slickpg

window

Permalink

package window

Visibility
  1. Public
  2. All

Type Members

  1. case class Over(_partitionBy: ConstArray[Node] = ConstArray.empty, _orderBy: ConstArray[(Node, Ordering)] = ConstArray.empty, _frameDef: Option[(String, String, Option[String])] = None) extends Product with Serializable

    Permalink

  2. trait PgWindowFuncSupport extends JdbcTypesComponent

    Permalink

  3. sealed class RowCursor extends AnyRef

    Permalink

  4. case class WindowFunc[R](_parts: AggFuncParts)(implicit evidence$3: TypedType[R]) extends Product with Serializable

    Permalink

  5. final case class WindowFuncExpr(aggFuncExpr: Node, partitionBy: ConstArray[Node], orderBy: ConstArray[(Node, Ordering)], frameDef: Option[(String, String, Option[String])] = None) extends SimplyTypedNode with Product with Serializable

    Permalink

    A window function call expression

  6. case class WindowFuncRep[R](_aggFuncExpr: Node, _partitionBy: ConstArray[Node] = ConstArray.empty, _orderBy: ConstArray[(Node, Ordering)] = ConstArray.empty, _frameDef: Option[(String, String, Option[String])] = None)(implicit evidence$4: TypedType[R]) extends TypedRep[R] with Product with Serializable

    Permalink

Value Members

  1. object FrameMode

    Permalink

  2. object PgWindowFuncSupport extends PgWindowFuncSupport with PostgresProfile

    Permalink

  3. object RowCursor

    Permalink

  4. object WindowFunc extends Serializable

    Permalink

    pg window function support, usage:

    pg window function support, usage:

    object AggregateLibrary {
  val Avg = new SqlFunction("avg")
}
def avg[T : JdbcType](c: Rep[T]) = agg.AggFuncRep[T](AggLibrary.Avg, List(c.toNode))
...
avg(salary).over.partitionBy(dept).orderBy(dept,salary)
                 .rowsFrame(RowCursor.UnboundPreceding, RowCursor.CurrentRow)
  <=> avg(salary) over (partition by dept order by dept, salary rows between unbounded preceding and current row)

Ungrouped