-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathgetdataprocessor.sql
More file actions
10 lines (10 loc) · 998 Bytes
/
getdataprocessor.sql
File metadata and controls
10 lines (10 loc) · 998 Bytes
1
2
3
4
5
6
7
8
9
10
CREATE OR REPLACE FUNCTION ti.getdataprocessor(_datasetid integer)
RETURNS TABLE(contactid integer, aliasid integer, contactname character varying, contactstatusid integer, familyname character varying, leadinginitials character varying, givennames character varying, suffix character varying, title character varying, phone character varying, fax character varying, email character varying, url character varying, address text, notes text)
LANGUAGE sql
AS $function$
SELECT ndb.contacts.contactid, ndb.contacts.aliasid, ndb.contacts.contactname, ndb.contacts.contactstatusid, ndb.contacts.familyname,
ndb.contacts.leadinginitials, ndb.contacts.givennames, ndb.contacts.suffix, ndb.contacts.title, ndb.contacts.phone, ndb.contacts.fax, ndb.contacts.email,
ndb.contacts.url, ndb.contacts.address, ndb.contacts.notes
FROM ndb.dataprocessors INNER JOIN ndb.contacts on ndb.dataprocessors.contactid = ndb.contacts.contactid
WHERE ndb.dataprocessors.datasetid = _datasetid;
$function$