https://wiki.ispirer.com/ 2026-04-14T07:44:42+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/ascii?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - ASCII Function PostgreSQL - ASCII Syntax ASCII() Description ASCII function returns decimal representation of the first character according to ASCII code set Equivalents in Other Databases Database Equivalent Oracle ASCII SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/bit-length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - BIT_LENGTH Function PostgreSQL - BIT_LENGTH Syntax BIT_LENGTH() Description BIT_LENGTH function returns number of bits in the string Equivalents in Other Databases Database Equivalent MySQL BIT_COUNT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/btrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - BTRIM Function PostgreSQL - BTRIM Syntax BTRIM() Description BTRIM function returns string with removed spaces from the left and/or from the right end Equivalents in Other Databases Database Equivalent Oracle TRIM IBM DB2 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/char-length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - CHAR_LENGTH Function PostgreSQL - CHAR_LENGTH Syntax CHAR_LENGTH() Description CHAR_LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 LENGTH MySQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/chr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - CHR Function PostgreSQL - CHR Syntax CHR() Description CHR function returns character with the binary equivalent of a number specified Equivalents in Other Databases Database Equivalent Oracle CHR SQL Server CHAR IBM DB2 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/get-bit?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - GET_BIT Function PostgreSQL - GET_BIT Syntax GET_BIT() Description GET_BIT function returns specified bit from string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/get-byte?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - GET_BYTE Function PostgreSQL - GET_BYTE Syntax GET_BYTE() Description GET_BYTE function returns specified byte from string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/initcap?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - INITCAP Function PostgreSQL - INITCAP Syntax INITCAP() Description INITCAP function returns string with the first letter of each word in uppercase Equivalents in Other Databases Database Equivalent Oracle INITCAP text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - LENGTH Function PostgreSQL - LENGTH Syntax LENGTH() Description LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 LENGTH MySQL CHAR_LENGTH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/lower?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - LOWER Function PostgreSQL - LOWER Syntax LOWER() Description LOWER function returns string with each letter in lowercase Equivalents in Other Databases Database Equivalent Oracle LOWER SQL Server LOWER IBM DB2 LCASE MySQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/lpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - LPAD Function PostgreSQL - LPAD Syntax LPAD() Description LPAD function returns left-padded string Equivalents in Other Databases Database Equivalent Oracle LPAD MySQL LPAD text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/ltrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - LTRIM Function PostgreSQL - LTRIM Syntax LTRIM() Description LTRIM function returns string with removed spaces from the left end Equivalents in Other Databases Database Equivalent Oracle LTRIM SQL Server LTRIM IBM DB2 LTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/octet-length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - OCTET_LENGTH Function PostgreSQL - OCTET_LENGTH Syntax OCTET_LENGTH() Description OCTET_LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 LENGTH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/overlay?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - OVERLAY Function PostgreSQL - OVERLAY Syntax OVERLAY() Description OVERLAY function returns string with the replaced symbols by replacement string in the specified position Equivalents in Other Databases Database Equivalent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/position?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - POSITION Function PostgreSQL - POSITION Syntax POSITION() Description POSITION function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR SQL Server CHARINDEX IBM DB2 LOCATE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/quote-ident?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - QUOTE_IDENT Function PostgreSQL - QUOTE_IDENT Syntax QUOTE_IDENT() Description QUOTE_IDENT function returns validated quoted identifier Equivalents in Other Databases Database Equivalent SQL Server QUOTENAME text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/quote-literal?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - QUOTE_LITERAL Function PostgreSQL - QUOTE_LITERAL Syntax QUOTE_LITERAL() Description QUOTE_LITERAL function returns validated quoted literal Equivalents in Other Databases Database Equivalent MySQL QUOTE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/regexp-matches?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - REGEXP_MATCHES Function PostgreSQL - REGEXP_MATCHES Syntax REGEXP_MATCHES() Description REGEXP_MATCHES function returns extract from string matching the pattern specified Equivalents in Other Databases Database Equivalent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/regexp-replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - REGEXP_REPLACE Function PostgreSQL - REGEXP_REPLACE Syntax REGEXP_REPLACE() Description REGEXP_REPLACE function returns string with the replaced occurrences of the specified pattern Equivalents in Other Databases Database Equivalent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/regexp-split-to-table?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - REGEXP_SPLIT_TO_TABLE Function PostgreSQL - REGEXP_SPLIT_TO_TABLE Syntax REGEXP_SPLIT_TO_TABLE() Description REGEXP_SPLIT_TO_TABLE function returns result set for splitted, by the regular expression as the delimiter, input string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/regexp-split-to-to-array?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - REGEXP_SPLIT_TO_TO_ARRAY Function PostgreSQL - REGEXP_SPLIT_TO_TO_ARRAY Syntax REGEXP_SPLIT_TO_TO_ARRAY() Description REGEXP_SPLIT_TO_TO_ARRAY function returns array for splitted, by the regular expression as the delimiter, input string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/repeat?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - REPEAT Function PostgreSQL - REPEAT Syntax REPEAT() Description REPEAT function returns string replicated the number of times specified Equivalents in Other Databases Database Equivalent SQL Server REPLICATE IBM DB2 REPEAT MySQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - REPLACE Function PostgreSQL - REPLACE Syntax REPLACE() Description REPLACE function returns string with the replaced occurrences of the specified string Equivalents in Other Databases Database Equivalent Oracle REPLACE SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/rpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - RPAD Function PostgreSQL - RPAD Syntax RPAD() Description RPAD function returns right-padded string Equivalents in Other Databases Database Equivalent Oracle RPAD MySQL RPAD text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/rtrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - RTRIM Function PostgreSQL - RTRIM Syntax RTRIM() Description RTRIM function returns string with removed spaces from the right end Equivalents in Other Databases Database Equivalent Oracle RTRIM SQL Server RTRIM IBM DB2 RTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/set-bit?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - SET_BIT Function PostgreSQL - SET_BIT Syntax SET_BIT() Description SET_BIT function returns string with the setted bit text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/set-byte?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - SET_BYTE Function PostgreSQL - SET_BYTE Syntax SET_BYTE() Description SET_BYTE function returns string with the setted byte text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/split-part?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - SPLIT_PART Function PostgreSQL - SPLIT_PART Syntax SPLIT_PART() Description SPLIT_PART function returns substring from a splitted by specified delimiter string having the order number specified text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/strpos?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - STRPOS Function PostgreSQL - STRPOS Syntax STRPOS() Description STRPOS function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR SQL Server CHARINDEX IBM DB2 LOCATE MySQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/substr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - SUBSTR Function PostgreSQL - SUBSTR Syntax SUBSTR() Description SUBSTR function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent Oracle SUBSTR SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/translate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - TRANSLATE Function PostgreSQL - TRANSLATE Syntax TRANSLATE() Description TRANSLATE function returns string with replaced occurrences of each character specified to its corresponding character specified Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/trim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - TRIM Function PostgreSQL - TRIM Syntax TRIM() Description TRIM function returns string with removed spaces from the left and/or from the right end Equivalents in Other Databases Database Equivalent Oracle TRIM IBM DB2 STRIP text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/functions/string-functions/upper?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL - UPPER Function PostgreSQL - UPPER Syntax UPPER() Description UPPER function returns string with each letter in uppercase Equivalents in Other Databases Database Equivalent Oracle UPPER SQL Server UPPER IBM DB2 UCASE MySQL