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