choose aggregate

Choose one value among many, used in particular to code a mutually exclusive choice as an aggregate. More...

Functions
ANYELEMENT	provsql.choose_function (ANYELEMENT state, ANYELEMENT data)
	Transition function for the choose aggregate (keeps first non-NULL value).
VOID	provsql.choose (ANYELEMENT)
	Aggregate that returns an arbitrary non-NULL value from a group.

Detailed Description

Choose one value among many, used in particular to code a mutually exclusive choice as an aggregate.

Function Documentation

choose()

VOID provsql.choose

(

ANYELEMENT

)

Aggregate that returns an arbitrary non-NULL value from a group.

Source code

provsql.sql line 4028

choose_function()

ANYELEMENT provsql.choose_function	(	ANYELEMENT	state,
		ANYELEMENT	data )

Transition function for the choose aggregate (keeps first non-NULL value).

Source code

provsql.sql line 4015