Sorry perhaps I wasn't clear.
FUNCTION fn_create_new_item()
_seq RECORD;
begin
SELECT INTO _seq NEXTVAL(''source_sequence'');
..do stuff, insert ....
PERFORM fn_b( _seq.next_value );
end;
FUNCTION fn_do_stuff_with_new_item_id( INT )
.....
Call to fn_b breaks because _seq.next_value is of type BIGINT.
On Tue, 2002-12-17 at 12:59, Tom Lane wrote:
> Hadley Willan <hadley.willan@deeper.co.nz> writes:
> > Reason being is that the column type for the sequence values is now
> > bigInt and of course I foolishly have a number of functions defined as
> > taking an INT.
>
> I don't follow. You're executing functions on the columns of a sequence
> object? Why?
>
> regards, tom lane
--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley.willan@deeper.co.nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.