-- Name: locationevent__communities(int(11)); Type: FUNCTION; Schema: public; Owner: -

--

--

-- Name: locationevent__communities__array(int(11)); Type: FUNCTION; Schema: public; Owner: -

--

--

-- Name: locationevent__communities(integer); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION locationevent__communities(locationevent_id integer) RETURNS SETOF text

    LANGUAGE sql STABLE

    AS $_$

SELECT commname.commname

FROM      commclass

LEFT JOIN commdetermination USING (commclass_id)

LEFT JOIN commconcept       USING (commconcept_id)

LEFT JOIN commname          USING (commname_id)

WHERE locationevent_id = $1

ORDER BY commname

$_$;

--

-- Name: locationevent__communities__array(integer); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION locationevent__communities__array(locationevent_id integer) RETURNS text[]

    LANGUAGE sql STABLE

    AS $_$

SELECT array_agg(locationevent__communities)

FROM locationevent__communities($1)

$_$;

--