Re: Changing a column's type
От | Hadley Willan |
---|---|
Тема | Re: Changing a column's type |
Дата | |
Msg-id | 1040083446.2931.28.camel@orac обсуждение исходный текст |
Ответ на | Re: Changing a column's type (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Changing a column's type
|
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: