Revision 11962
Added by Aaron Marcuse-Kubitza almost 11 years ago
| 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
schemas/vegbien.sql: added project_contributors()