summaryrefslogtreecommitdiff
path: root/sql/modules/Person.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/modules/Person.sql')
-rw-r--r--sql/modules/Person.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Person.sql b/sql/modules/Person.sql
index 98b4dcb1..cd84fefc 100644
--- a/sql/modules/Person.sql
+++ b/sql/modules/Person.sql
@@ -106,7 +106,7 @@ $$
DECLARE out_row RECORD;
BEGIN
FOR out_row IN
- SELECT cc.class, c.description, c.contact
+ SELECT cc.class, cc.id, c.description, c.contact
FROM person_to_contact c
JOIN contact_class cc ON (c.contact_class_id = cc.id)
JOIN person p ON (c.person_id = p.id)