Project

General

Profile

« Previous | Next » 

Revision 11962

schemas/vegbien.sql: added project_contributors()

View differences:

schemas/vegbien.my.sql
565 565

  
566 566

  
567 567
--
568
-- Name: project_contributors(int(11)); Type: FUNCTION; Schema: public; Owner: -
569
--
570

  
571

  
572

  
573

  
574
--
575
-- Name: FUNCTION project_contributors(project_id int(11)); Type: COMMENT; Schema: public; Owner: -
576
--
577

  
578

  
579

  
580

  
581
--
568 582
-- Name: rm_version_suffix(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
569 583
--
570 584

  
schemas/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