Project

General

Profile

« Previous | Next » 

Revision 11962

schemas/vegbien.sql: added project_contributors()

View differences:

vegbien.sql
1189 1189

  
1190 1190

  
1191 1191
--
1192
-- Name: project_contributors(integer); Type: FUNCTION; Schema: public; Owner: -
1193
--
1194

  
1195
CREATE FUNCTION project_contributors(project_id integer) RETURNS SETOF text
1196
    LANGUAGE sql STABLE
1197
    AS $_$
1198
SELECT fullname
1199
FROM projectcontributor
1200
LEFT JOIN party USING (party_id)
1201
WHERE project_id = $1
1202
ORDER BY fullname
1203
$_$;
1204

  
1205

  
1206
--
1207
-- Name: FUNCTION project_contributors(project_id integer); Type: COMMENT; Schema: public; Owner: -
1208
--
1209

  
1210
COMMENT ON FUNCTION project_contributors(project_id integer) IS 'usage: array(SELECT project_contributors(...))';
1211

  
1212

  
1213
--
1192 1214
-- Name: rm_version_suffix(text); Type: FUNCTION; Schema: public; Owner: -
1193 1215
--
1194 1216

  

Also available in: Unified diff