Re: [GENERAL] strange behavior of plpgsql function

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

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 f

[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 varch