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

SQL Language Extension: COALESCE

Function:
    Allow a column value to be calculated by a number of expressions, 
    the first expression returning a non NULL value is returned as the 
    column value

Author:
    Arno Brinkman <firebird@abvisie.nl>

Format:

<case abbreviation> ::=
    | COALESCE <left paren> <value expression> { <comma> <value expression> }... <right paren>

Syntax Rules:
    1) COALESCE (V1, V2) is equivalent to the following <case specification>:
         CASE WHEN V1 IS NOT NULL THEN V1 ELSE V2 END
    2) COALESCE (V1, V2,..., Vn), for n >= 3, is equivalent to the following
         <case specification>:
         CASE WHEN V1 IS NOT NULL THEN V1 ELSE COALESCE (V2,...,Vn) END

Notes:
    See also README.data_type_results_of_aggregations.txt

Examples:
A)

SELECT
    PROJ_NAME AS Projectname,
    COALESCE(e.FULL_NAME,'[> not assigned <]') AS Employeename
  FROM
    PROJECT p
    LEFT JOIN EMPLOYEE e ON (e.EMP_NO = p.TEAM_LEADER)

B)
  SELECT
    COALESCE(Phone,MobilePhone,'Unknown') AS "Phonenumber"
  FROM
    Relations