[ http://issues.apache.org/jira/browse/DERBY-712?page=all ]
Mike Matrigali updated DERBY-712:
---------------------------------
Component: SQL
> Support for sequences
> ---------------------
>
> Key: DERBY-712
> URL: http://issues.apache.org/jira/browse/DERBY-712
> Project: Derby
> Type: New Feature
> Components: SQL
> Environment: feature request
> Reporter: Tony Dahbura
>
> Would like to see support added for sequences. This would permit a select
> against the sequence to always obtain a ever increasing/decreasing value.
> The identity column works fine but there are times for applications where the
> application needs to obtain the sequence number and use it prior to the
> database write. Subsequent calls to the table/column would result in a new
> number on each call.
> SQL such as the following:
> SELECT NEXT VALUE FOR sequence_name FROM sometable ; would result in a next
> value.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
