phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Samarth Jain <samarth.j...@gmail.com>
Subject Re: Selecting from a sequence
Date Wed, 09 Apr 2014 05:23:57 GMT
Would it help to query SYSTEM.SEQUENCE table instead?

For ex - "SELECT NEXT value FOR seq FROM SYSTEM.\"SEQUENCE\"".

This way you won't have to worry about rows being present in the table.


On Tue, Apr 8, 2014 at 6:26 PM, Dan Di Spaltro <dan.dispaltro@gmail.com>wrote:

> So I created a new table and sequence.  My typical pattern for that is
> selecting from the sequence using a table, but I noticed if the table is
> empty it doesn't select anything.  While in practice this won't really be a
> problem but it's a pain when testing, is this intended behavior?
>
> Thanks!
>
> -Dan
>
> --
> Dan Di Spaltro
>

Mime
View raw message