String functions like cast, lower, upper, trim and substring will work with these BLOBs, as well as concatenation and assignment to string types. O Text BLOBs Can Masquerade as Long VARCHARs At various levels of evaluation, the engine now treats text BLOBs that are within the 32,765-byte size limit as though they were varchars. O New Built-in Functions Dozens of built-in functions replacing many of the UDFs from the Firebird-distributed UDF libraries. O LIST() function A new aggregate function LIST() retrieves all of the SOMETHINGs in a group and aggregates them into a comma-separated list. O UPDATE OR INSERT Statement New UPDATE OR INSERT for MERGE functionality: now you can write a statement that is capable of performing either an update to an existing record or an insert, depending on whether the targeted record exists. O RETURNING Clause Optional RETURNING clause for all singleton operations, update, insert and delete operations. O Common Table Expressions (CTEs) Standards-compliant common table expressions, which make dynamic recursive queries possible. These pre-defined tables are instantiated on request for connection-specific or transaction-specific use with non-persistent data, which the Firebird engine stores in temporary files. O Global Temporary Tables SQL standards-compliant global temporary tables have been implemented. O Database Triggers User-defined PSQL modules that can be designed to fire in various connection-level and transaction-level events.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |