diff options
Diffstat (limited to 'sql/modules/Person.sql')
-rw-r--r-- | sql/modules/Person.sql | 2 |
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) |