> "David Durst" <ddurst@larubber.com> writes:
>> insert into journal_lines
>> (entry_id,account_id,line_type,line_amount)
>> values (eid,aid,ltype,amount);
>> select into line * from journal_lines where entry_id = eid AND
>> account_id = aid AND ltype = ltype;
>
> I bet that last should be line_type = ltype?
Just to let you know, changing ltype to line_type fixed the problem.
But I still think your point about the function selecting more than
one line is valid.
The problem is, the journal_line_id is not created until the insert
occurs and there is no other unique ident than the journal_line_id.
