On Sat, Apr 4, 2009 at 10:07 AM, Justin <justin@xxxxxxxxxxxxxxx> wrote: > I think i may be the way the function is being called?? > > if you are doing Select fnvs.docrelatedassociatedetails() > > it will not return any records, it needs to be > > Select * From fnvs.docrelatedassociatedetails() select func(); will return a set of composite type for sql functions, and error for plpgsql functions < 8.4. Starting with 8.4, plpgsql functions will work as sql functions do. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general