[GENERAL] strange behavior of plpgsql function

2009-04-04 Thread c k
Hi all, I am facing a small but strange problem when using a plpgsql function as below. CREATE OR REPLACE FUNCTION fnvs.docrelatedassociatedetails(p_docid integer, p_addtype smallint, p_associateid integer, OUT docid integer, OUT associateid integer, OUT addressline1 varchar,OUT addressline2

Re: [GENERAL] strange behavior of plpgsql function

2009-04-04 Thread Justin
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() c k wrote: Hi all, I am facing a small but strange problem when using a plpgsql

Re: [GENERAL] strange behavior of plpgsql function

2009-04-04 Thread Merlin Moncure
On Sat, Apr 4, 2009 at 10:07 AM, Justin jus...@emproshunts.com 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