Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
sqlways:postgresql:functions [September 23, 2009, 12:01:33 PM] leonovsqlways:postgresql:functions [May 31, 2023, 05:28:10 PM] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +\\
 +[[https://www.ispirer.com|Ispirer Website]]
 +[[https://www.ispirer.com/products/postgresql-migration|Ispirer Capabilities - PostgreSQL Migration]]
 +[[https://www.ispirer.com/download/download-demo|Free Trial]]
 +===== PostgreSQL Functions =====
 +
 +  * **[[sqlways:postgresql/functions/mapping-to-other-databases |SQL Functions Mapping to Other Databases]]**
 +  * **[[sqlways:postgresql/functions/numeric-functions |Numeric Functions]]**
 +      * [[sqlways:postgresql/functions/numeric-functions/abs |ABS]]
 +      * [[sqlways:postgresql/functions/numeric-functions/acos |ACOS]]
 +      * [[sqlways:postgresql/functions/numeric-functions/asin |ASIN]]
 +      * [[sqlways:postgresql/functions/numeric-functions/atan |ATAN]]
 +      * [[sqlways:postgresql/functions/numeric-functions/atan2 |ATAN2]]
 +      * [[sqlways:postgresql/functions/numeric-functions/cbrt |CBRT]]
 +      * [[sqlways:postgresql/functions/numeric-functions/ceil |CEIL]]
 +      * [[sqlways:postgresql/functions/numeric-functions/cos |COS]]
 +      * [[sqlways:postgresql/functions/numeric-functions/cot |COT]]
 +      * [[sqlways:postgresql/functions/numeric-functions/degrees |DEGREES]]
 +      * [[sqlways:postgresql/functions/numeric-functions/div |DIV]]
 +      * [[sqlways:postgresql/functions/numeric-functions/exp |EXP]]
 +      * [[sqlways:postgresql/functions/numeric-functions/floor |FLOOR]]
 +      * [[sqlways:postgresql/functions/numeric-functions/ln |LN]]
 +      * [[sqlways:postgresql/functions/numeric-functions/log |LOG]]
 +      * [[sqlways:postgresql/functions/numeric-functions/mod |MOD]]
 +      * [[sqlways:postgresql/functions/numeric-functions/pi |PI]]
 +      * [[sqlways:postgresql/functions/numeric-functions/power |POWER]]
 +      * [[sqlways:postgresql/functions/numeric-functions/radians |RADIANS]]
 +      * [[sqlways:postgresql/functions/numeric-functions/random |RANDOM]]
 +      * [[sqlways:postgresql/functions/numeric-functions/round |ROUND]]
 +      * [[sqlways:postgresql/functions/numeric-functions/sign |SIGN]]
 +      * [[sqlways:postgresql/functions/numeric-functions/sin |SIN]]
 +      * [[sqlways:postgresql/functions/numeric-functions/sqrt |SQRT]]
 +      * [[sqlways:postgresql/functions/numeric-functions/tan |TAN]]
 +      * [[sqlways:postgresql/functions/numeric-functions/trunc |TRUNC]]
 +  * **[[sqlways:postgresql/functions/string-functions |String Functions]]**
 +      * [[sqlways:postgresql/functions/string-functions/ascii |ASCII]]
 +      * [[sqlways:postgresql/functions/string-functions/bit-length |BIT_LENGTH]]
 +      * [[sqlways:postgresql/functions/string-functions/btrim |BTRIM]]
 +      * [[sqlways:postgresql/functions/string-functions/chr |CHR]]
 +      * [[sqlways:postgresql/functions/string-functions/get-bit |GET_BIT]]
 +      * [[sqlways:postgresql/functions/string-functions/get-byte |GET_BYTE]]
 +      * [[sqlways:postgresql/functions/string-functions/initcap |INITCAP]]
 +      * [[sqlways:postgresql/functions/string-functions/length |LENGTH]]
 +      * [[sqlways:postgresql/functions/string-functions/char-length |CHAR_LENGTH]]
 +      * [[sqlways:postgresql/functions/string-functions/lower |LOWER]]
 +      * [[sqlways:postgresql/functions/string-functions/lpad |LPAD]]
 +      * [[sqlways:postgresql/functions/string-functions/ltrim |LTRIM]]
 +      * [[sqlways:postgresql/functions/string-functions/octet-length |OCTET_LENGTH]]
 +      * [[sqlways:postgresql/functions/string-functions/overlay |OVERLAY]]
 +      * [[sqlways:postgresql/functions/string-functions/position |POSITION]]
 +      * [[sqlways:postgresql/functions/string-functions/quote-ident |QUOTE_IDENT]]
 +      * [[sqlways:postgresql/functions/string-functions/quote-literal |QUOTE_LITERAL]]
 +      * [[sqlways:postgresql/functions/string-functions/regexp-matches |REGEXP_MATCHES]]
 +      * [[sqlways:postgresql/functions/string-functions/regexp-replace |REGEXP_REPLACE]]
 +      * [[sqlways:postgresql/functions/string-functions/regexp-split-to-table |REGEXP_SPLIT_TO_TABLE]]
 +      * [[sqlways:postgresql/functions/string-functions/regexp-split-to-to-array |REGEXP_SPLIT_TO_TO_ARRAY]]
 +      * [[sqlways:postgresql/functions/string-functions/repeat |REPEAT]]
 +      * [[sqlways:postgresql/functions/string-functions/replace |REPLACE]]
 +      * [[sqlways:postgresql/functions/string-functions/rpad |RPAD]]
 +      * [[sqlways:postgresql/functions/string-functions/rtrim |RTRIM]]
 +      * [[sqlways:postgresql/functions/string-functions/set-bit |SET_BIT]]
 +      * [[sqlways:postgresql/functions/string-functions/set-byte |SET_BYTE]]
 +      * [[sqlways:postgresql/functions/string-functions/split-part |SPLIT_PART]]
 +      * [[sqlways:postgresql/functions/string-functions/strpos |STRPOS]]
 +      * [[sqlways:postgresql/functions/string-functions/substr |SUBSTR]]
 +      * [[sqlways:postgresql/functions/string-functions/translate |TRANSLATE]]
 +      * [[sqlways:postgresql/functions/string-functions/trim |TRIM]]
 +      * [[sqlways:postgresql/functions/string-functions/upper |UPPER]]
 +  * **[[sqlways:postgresql/functions/date-and-time-functions |Date and Time Functions]]**
 +      * [[sqlways:postgresql/functions/date-and-time-functions/age |AGE]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/clock-timestamp |CLOCK_TIMESTAMP]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/current-date |CURRENT_DATE]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/current-time |CURRENT_TIME]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/current-timestamp |CURRENT_TIMESTAMP]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/date-part |DATE_PART]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/date-trunc |DATE_TRUNC]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/extract |EXTRACT]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/isfinite |ISFINITE]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/justify-days |JUSTIFY_DAYS]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/justify-hours |JUSTIFY_HOURS]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/justify-interval |JUSTIFY_INTERVAL]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/localtime |LOCALTIME]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/localtimestamp |LOCALTIMESTAMP]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/now |NOW]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/statement-timestamp |STATEMENT_TIMESTAMP]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/timeofday |TIMEOFDAY]]
 +      * [[sqlways:postgresql/functions/date-and-time-functions/transaction-timestampe |TRANSACTION_TIMESTAMPE]]
 +  * **[[sqlways:postgresql/functions/analitic-and-aggregate-functions |Analitic and Aggregate Functions]]**
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/array-agg |ARRAY_AGG]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/avg |AVG]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/bit-and |BIT_AND]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/bit-or |BIT_OR]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/bool-and |BOOL_AND]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/bool-or |BOOL_OR]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/corr |CORR]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/count |COUNT]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/covar-pop |COVAR_POP]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/covar-samp |COVAR_SAMP]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/every |EVERY]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/max |MAX]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/min |MIN]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-avgx |REGR_AVGX]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-avgy |REGR_AVGY]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-count |REGR_COUNT]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-intercept |REGR_INTERCEPT]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-r2 |REGR_R2]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-slope |REGR_SLOPE]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-sxx |REGR_SXX]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-sxy |REGR_SXY]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/regr-syy |REGR_SYY]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/stddev |STDDEV]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/stddev-pop |STDDEV_POP]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/stddev-samp |STDDEV_SAMP]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/sum |SUM]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/var-pop |VAR_POP]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/var-samp |VAR_SAMP]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/variance |VARIANCE]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/xmlagg |XMLAGG]]
 +      * [[sqlways:postgresql/functions/analitic-and-aggregate-functions/width-bucket |WIDTH_BUCKET]]
 +  * **[[sqlways:postgresql/functions/conversion-functions |Conversion Functions]]**
 +      * [[sqlways:postgresql/functions/conversion-functions/to-char |TO_CHAR]]
 +      * [[sqlways:postgresql/functions/conversion-functions/to-date |TO_DATE]]
 +      * [[sqlways:postgresql/functions/conversion-functions/to-timestamp |TO_TIMESTAMP]]
 +      * [[sqlways:postgresql/functions/conversion-functions/convert |CONVERT]]
 +      * [[sqlways:postgresql/functions/conversion-functions/convert-from |CONVERT_FROM]]
 +      * [[sqlways:postgresql/functions/conversion-functions/convert-to |CONVERT_TO]]
 +      * [[sqlways:postgresql/functions/conversion-functions/decode |DECODE]]
 +      * [[sqlways:postgresql/functions/conversion-functions/encode |ENCODE]]
 +      * [[sqlways:postgresql/functions/conversion-functions/to-ascii |TO_ASCII]]
 +      * [[sqlways:postgresql/functions/conversion-functions/to-hex |TO_HEX]]
 +  * **[[sqlways:postgresql/functions/xml-functions |XML Functions]]**
 +      * [[sqlways:postgresql/functions/xml-functions/cursor-to-xml |CURSOR_TO_XML]]
 +      * [[sqlways:postgresql/functions/xml-functions/query-to-xml |QUERY_TO_XML]]
 +      * [[sqlways:postgresql/functions/xml-functions/table-to-xml |TABLE_TO_XML]]
 +      * [[sqlways:postgresql/functions/xml-functions/xmlagg |XMLAGG]]
 +      * [[sqlways:postgresql/functions/xml-functions/xmlcomment |XMLCOMMENT]]
 +      * [[sqlways:postgresql/functions/xml-functions/xmlconcat |XMLCONCAT]]
 +      * [[sqlways:postgresql/functions/xml-functions/xmlelement |XMLELEMENT]]
 +      * [[sqlways:postgresql/functions/xml-functions/xmlforest |XMLFOREST]]
 +      * [[sqlways:postgresql/functions/xml-functions/xmlpi |XMLPI]]
 +      * [[sqlways:postgresql/functions/xml-functions/xmlroot |XMLROOT]]
 +      * [[sqlways:postgresql/functions/xml-functions/xpath |XPATH]]
  

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.