27.08.2018 19:05, Adriano dos Santos Fernandes wrote:
On 27/08/2018 12:59, Vlad Khorsun wrote:

   How it is related with consistency ? Also, we already have such
behaviour
even within single statement.


Show me it, please.

  select any_function() ... from ... order by 1

For example, gen_id():

SQL> select gen_id(g1, 0) from rdb$database;

               GEN_ID
=====================
                    0

SQL> select gen_id(g1, 1) from rdb$database order by 1;

               GEN_ID
=====================
                    2

SQL> select gen_id(g1, 0) from rdb$database;

               GEN_ID
=====================
                    2


Regards,
Vlad

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to