pears.personinfo

Gives consolidated address and phone etc fields for a Person record

CREATE VIEW "pears"."personinfo"( "personid",
  "addressonline","phones" ) 
  AS SELECT "person"."personid","pears"."GetPersonAddressOnLine"("person"."personid"),
    "pears"."GetPersonPhoneInBlock"("person"."personid") FROM "pears"."person"
GO
 
COMMENT ON VIEW "pears"."personinfo" IS 
	'Gives consolidated address and phone etc fields for a Person record'
GO
 
COMMENT TO PRESERVE FORMAT ON VIEW "pears"."personinfo" IS 
{CREATE VIEW personinfo 
(personid,addressonline,phones)
AS SELECT person.personid,pears.GetPersonAddressOnLine(person.personid),
pears.GetPersonPhoneInBlock(person.personid) FROM pears.person
}