SQL help

[william humphrey]

Can that kind of create sequence be done after the fact of table
finished and data already in?

On Fri, Jan 3, 2014 at 11:23 AM, Ruslan Zasukhin
<ruslan_zasukhin at valentina-db.com> wrote:
> On 1/3/14, 4:46 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:
>
>> I've been thinking that a sequence maintained with a trigger might be
>> very useful for other things too. I never thought of numbering
>> sequentially the voyages of each vessel. It solves some other
>> problems. Right now voyage numbers increment from zero at the start of
>> each new year (which is what caused the problem) but there is no
>> reason why I can't have an extra field which has every voyage for that
>> vessel down through the years.
>
> Do you talk about CERATE SEQUENCE?
>
>
> For simple case, consider SERIAL32 or SERIAL64 pseudo-types,
> As even more simple things.
>
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina



-- 
http://www.bluewatermaritime.com