sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. sha512('abc'::bytea) c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes these expressions, the desired time zone zone can be specified either as a text value (e.g., 'Ameri- ca/Los_Angeles') or as an interval (e.g., INTERVAL '-08:00'). In the text case, a time zone name can be

sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. sha512('abc'::bytea) c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes these expressions, the desired time zone zone can be specified either as a text value (e.g., 'Ameri- ca/Los_Angeles') or as an interval (e.g., INTERVAL '-08:00'). In the text case, a time zone name can be

sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. sha512('abc'::bytea) c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes these expressions, the desired time zone zone can be specified either as a text value (e.g., 'Ameri- ca/Los_Angeles') or as an interval (e.g., INTERVAL '-08:00'). In the text case, a time zone name can be

allowed in ISO 8601) 04:05:06 PST time zone specified by abbreviation 2003-04-12 04:05:06 Ameri- ca/New_York time zone specified by full name Table 8.12. Time Zone Input Example Description PST Abbreviation c2358bae- ca134c825a7 sha512(bytea) bytea SHA-512 hash sha512('abc') \xddaf35a193617abac- c417349ae204131 12e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f in the context postgresql-beta1 hword_part Hyphenated word part, all letters lógico or matemáti- ca in the context lógi- co-matemática hword_numpart Hyphenated word part, letters and digits beta1 in

sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. sha512('abc'::bytea) c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes 000114 5 | {Atlanta, GA} | {f,f} | 0.001633 | 3.3e-05 6 | {Sacramento, CA} | {f,f} | 0.001433 | 7.8e-05 7 | {Miami, FL} | {f,f} | 0.0014 |

sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. 246 Functions c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes 000114 5 | {Atlanta, GA} | {f,f} | 0.001633 | 3.3e-05 6 | {Sacramento, CA} | {f,f} | 0.001433 | 7.8e-05 7 | {Miami, FL} | {f,f} | 0.0014 |

sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. sha512('abc'::bytea) c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes 000114 5 | {Atlanta, GA} | {f,f} | 0.001633 | 3.3e-05 6 | {Sacramento, CA} | {f,f} | 0.001433 | 7.8e-05 7 | {Miami, FL} | {f,f} | 0.0014 |

sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. sha512('abc'::bytea) c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes these expressions, the desired time zone zone can be specified either as a text value (e.g., 'Ameri- ca/Los_Angeles') or as an interval (e.g., INTERVAL '-08:00'). In the text case, a time zone name can be

\xcb00753f45a35e8b- b5a03d699ac65007 272c32ab0ed- ed1631a8b605a43f- f5bed 8086072ba1e7c- c2358bae- ca134c825a7 245 Functions and Operators Function Return Type Description Example Result sha512(bytea) c417349ae204131 12e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f get_byte and set_byte number the first byte of a binary string as byte 0. get_bit and set_bit number 0.000114 5 | {Atlanta, GA} | {f,f} | 0.001633 | 3.3e-05 6 | {Sacramento, CA} | {f,f} | 0.001433 | 7.8e-05 7 | {Miami, FL} | {f,f} | 0.0014 |

sha384('abc'::bytea) → \xcb00753f45a35e8bb5a03d699ac65007 272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358bae- ca134c825a7 sha512 ( bytea ) → bytea Computes the SHA-512 hash of the binary string. sha512('abc'::bytea) c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count integer ] ) → bytea Extracts the substring of bytes these expressions, the desired time zone zone can be specified either as a text value (e.g., 'Ameri- ca/Los_Angeles') or as an interval (e.g., INTERVAL '-08:00'). In the text case, a time zone name can be