Gecko [ tanishkshah.com ]

Linux evo.fastest-server.com 5.14.0-284.1101.el9.tuxcare.11.els11.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 14 13:30:35 UTC 2026 x86_64
LiteSpeed
Server IP : 103.249.112.113 & Your IP : 216.73.217.135
Domains : 988 Domain
User : tanishks

Name	Size	Permission	Date
README.PSQL_stack_trace.txt	1.96 KB	-rw-r--r--	2026-04-17 16:36
README.aggregate_filter.md	941 B	-rw-r--r--	2026-04-17 16:36
README.aggregate_tracking	3.88 KB	-rw-r--r--	2026-04-17 16:36
README.alternate_string_quoting.txt	846 B	-rw-r--r--	2026-04-17 16:36
README.autonomous_transactions.txt	1.31 KB	-rw-r--r--	2026-04-17 16:36
README.blob_append.md	4.99 KB	-rw-r--r--	2026-04-17 16:36
README.builtin_functions.txt	29.49 KB	-rw-r--r--	2026-04-17 16:36
README.case	1.71 KB	-rw-r--r--	2026-04-17 16:36
README.coalesce	1.04 KB	-rw-r--r--	2026-04-17 16:36
README.column_type_psql.txt	871 B	-rw-r--r--	2026-04-17 16:36
README.common_table_expressions	4.78 KB	-rw-r--r--	2026-04-17 16:36
README.context_variables	4.66 KB	-rw-r--r--	2026-04-17 16:36
README.context_variables2	8.47 KB	-rw-r--r--	2026-04-17 16:36
README.cumulative_roles.txt	2.27 KB	-rw-r--r--	2026-04-17 16:36
README.current_time	814 B	-rw-r--r--	2026-04-17 16:36
README.cursor_variables.txt	2.75 KB	-rw-r--r--	2026-04-17 16:36
README.cursors	2.43 KB	-rw-r--r--	2026-04-17 16:36
README.data_type_results_of_aggregations.txt	1.56 KB	-rw-r--r--	2026-04-17 16:36
README.data_types	8.31 KB	-rw-r--r--	2026-04-17 16:36
README.db_triggers.txt	1.8 KB	-rw-r--r--	2026-04-17 16:36
README.ddl.txt	22.52 KB	-rw-r--r--	2026-04-17 16:36
README.ddl_access.txt	1.53 KB	-rw-r--r--	2026-04-17 16:36
README.ddl_triggers.txt	11.67 KB	-rw-r--r--	2026-04-17 16:36
README.default_parameters	1.91 KB	-rw-r--r--	2026-04-17 16:36
README.derived_tables.txt	2.69 KB	-rw-r--r--	2026-04-17 16:36
README.distinct	813 B	-rw-r--r--	2026-04-17 16:36
README.domains_psql.txt	933 B	-rw-r--r--	2026-04-17 16:36
README.exception_handling	2.44 KB	-rw-r--r--	2026-04-17 16:36
README.execute_block	1.45 KB	-rw-r--r--	2026-04-17 16:36
README.execute_statement	4.24 KB	-rw-r--r--	2026-04-17 16:36
README.execute_statement2	9.54 KB	-rw-r--r--	2026-04-17 16:36
README.explicit_locks	5.91 KB	-rw-r--r--	2026-04-17 16:36
README.expression_indices	1.3 KB	-rw-r--r--	2026-04-17 16:36
README.external_connections_pool	4.31 KB	-rw-r--r--	2026-04-17 16:36
README.floating_point_types.md	2.33 KB	-rw-r--r--	2026-04-17 16:36
README.global_temporary_tables	3.43 KB	-rw-r--r--	2026-04-17 16:36
README.hex_literals.txt	1.13 KB	-rw-r--r--	2026-04-17 16:36
README.identity_columns.txt	3.24 KB	-rw-r--r--	2026-04-17 16:36
README.iif	541 B	-rw-r--r--	2026-04-17 16:36
README.isc_info_xxx	3.61 KB	-rw-r--r--	2026-04-17 16:36
README.joins.txt	1.23 KB	-rw-r--r--	2026-04-17 16:36
README.keywords	5.26 KB	-rw-r--r--	2026-04-17 16:36
README.leave_labels	1.68 KB	-rw-r--r--	2026-04-17 16:36
README.length	486 B	-rw-r--r--	2026-04-17 16:36
README.linger	1.34 KB	-rw-r--r--	2026-04-17 16:36
README.list	1.04 KB	-rw-r--r--	2026-04-17 16:36
README.management_statements_psql.md	925 B	-rw-r--r--	2026-04-17 16:36
README.mapping.html	14.91 KB	-rw-r--r--	2026-04-17 16:36
README.merge.txt	1.77 KB	-rw-r--r--	2026-04-17 16:36
README.null_value	23 B	-rw-r--r--	2026-04-17 16:36
README.nullif	611 B	-rw-r--r--	2026-04-17 16:36
README.offset_fetch.txt	1.69 KB	-rw-r--r--	2026-04-17 16:36
README.order_by_expressions_nulls	1.67 KB	-rw-r--r--	2026-04-17 16:36
README.packages.txt	5.12 KB	-rw-r--r--	2026-04-17 16:36
README.plan	3.49 KB	-rw-r--r--	2026-04-17 16:36
README.regr_functions.txt	1.14 KB	-rw-r--r--	2026-04-17 16:36
README.returning	2.91 KB	-rw-r--r--	2026-04-17 16:36
README.rows	1.34 KB	-rw-r--r--	2026-04-17 16:36
README.savepoints	4.08 KB	-rw-r--r--	2026-04-17 16:36
README.scrollable_cursors.txt	3.06 KB	-rw-r--r--	2026-04-17 16:36
README.select_expressions	2.18 KB	-rw-r--r--	2026-04-17 16:36
README.sequence_generators	1.68 KB	-rw-r--r--	2026-04-17 16:36
README.set_bind.md	4.49 KB	-rw-r--r--	2026-04-17 16:36
README.set_role	768 B	-rw-r--r--	2026-04-17 16:36
README.set_transaction.txt	1.63 KB	-rw-r--r--	2026-04-17 16:36
README.similar_to.txt	9.53 KB	-rw-r--r--	2026-04-17 16:36
README.sql_security.txt	5.51 KB	-rw-r--r--	2026-04-17 16:36
README.statistical_functions.txt	1.6 KB	-rw-r--r--	2026-04-17 16:36
README.subroutines.txt	4.23 KB	-rw-r--r--	2026-04-17 16:36
README.substring_similar.txt	1.2 KB	-rw-r--r--	2026-04-17 16:36
README.time_zone.md	14.34 KB	-rw-r--r--	2026-04-17 16:36
README.trim	997 B	-rw-r--r--	2026-04-17 16:36
README.universal_triggers	2.77 KB	-rw-r--r--	2026-04-17 16:36
README.update_or_insert	1.38 KB	-rw-r--r--	2026-04-17 16:36
README.user_management	4.43 KB	-rw-r--r--	2026-04-17 16:36
README.view_updates	23 B	-rw-r--r--	2026-04-17 16:36
README.window_functions.md	14.92 KB	-rw-r--r--	2026-04-17 16:36

Rename

-------------------
Sequence generators
-------------------

Function:
    A sequence generator is a mechanism for generating successive exact
    numeric values, one at a time. A sequence generator is a named schema
    object.

Syntax rules:
    CREATE { SEQUENCE | GENERATOR } <name>
    DROP { SEQUENCE | GENERATOR } <name>
    SET GENERATOR <name> TO <start_value>
    ALTER SEQUENCE <name> RESTART WITH <start_value>
    GEN_ID (<name>, <increment_value>)
    NEXT VALUE FOR <name>

Type:
    INTEGER in dialect 1, BIGINT in dialect 3

Example(s):
    1. CREATE SEQUENCE S_EMPLOYEE;
    2. ALTER SEQUENCE S_EMPLOYEE RESTART WITH 0;
    3. SELECT GEN_ID(S_EMPLOYEE, 1) FROM RDB$DATABASE;
    4. INSERT INTO EMPLOYEE (ID, NAME) VALUES (NEXT VALUE FOR S_EMPLOYEE, 'John Smith');

Note(s):
    1. SEQUENCE is a syntax term declared in the SQL specification, while
       GENERATOR is a legacy InterBase syntax term. It's recommended to use
       the standard SEQUENCE syntax in your applications.
    2. Currently, increment values not equal to 1 (one) could be used only via
       the GEN_ID function. The future versions are expected to provide full
       support for SQL-99 sequence generators (which allows the required
       increment values to be specified at the DDL level), so it's recommended
       to get new sequential values via NEXT VALUE FOR value expression instead
       of the GEN_ID function, unless it's vitally important to use other
       increment values.
    3. GEN_ID(<name>, 0) allows you to retrieve the current sequence value,
       but it should be never used in insert/update statements, as it produces a
       high risk of uniqueness violations in a concurrent environment.