Both sides previous revisionPrevious revision | |
sqlways:postgresql:functions [September 23, 2009, 12:01:33 PM] – leonov | sqlways:postgresql:functions [May 31, 2023, 05:28:10 PM] (current) – external edit 127.0.0.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]] |
| |