Server IP : 85.214.239.14 / Your IP : 18.222.182.226 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/2/cwd/proc/2/root/proc/2/task/2/root/usr/share/postgresql/15/extension/ |
Upload File : |
/* contrib/ltree/ltree--1.1--1.2.sql */ -- complain if script is sourced in psql, rather than via ALTER EXTENSION \echo Use "ALTER EXTENSION ltree UPDATE TO '1.2'" to load this file. \quit CREATE FUNCTION ltree_recv(internal) RETURNS ltree AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; CREATE FUNCTION ltree_send(ltree) RETURNS bytea AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; ALTER TYPE ltree SET ( RECEIVE = ltree_recv, SEND = ltree_send ); CREATE FUNCTION lquery_recv(internal) RETURNS lquery AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; CREATE FUNCTION lquery_send(lquery) RETURNS bytea AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; ALTER TYPE lquery SET ( RECEIVE = lquery_recv, SEND = lquery_send ); CREATE FUNCTION ltxtq_recv(internal) RETURNS ltxtquery AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; CREATE FUNCTION ltxtq_send(ltxtquery) RETURNS bytea AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; ALTER TYPE ltxtquery SET ( RECEIVE = ltxtq_recv, SEND = ltxtq_send ); CREATE FUNCTION ltree_gist_options(internal) RETURNS void AS 'MODULE_PATHNAME', 'ltree_gist_options' LANGUAGE C IMMUTABLE PARALLEL SAFE; CREATE FUNCTION _ltree_gist_options(internal) RETURNS void AS 'MODULE_PATHNAME', '_ltree_gist_options' LANGUAGE C IMMUTABLE PARALLEL SAFE; ALTER OPERATOR FAMILY gist_ltree_ops USING gist ADD FUNCTION 10 (ltree) ltree_gist_options (internal); ALTER OPERATOR FAMILY gist__ltree_ops USING gist ADD FUNCTION 10 (_ltree) _ltree_gist_options (internal); ALTER OPERATOR < (ltree, ltree) SET (RESTRICT = scalarltsel, JOIN = scalarltjoinsel); ALTER OPERATOR <= (ltree, ltree) SET (RESTRICT = scalarlesel, JOIN = scalarlejoinsel); ALTER OPERATOR >= (ltree, ltree) SET (RESTRICT = scalargesel, JOIN = scalargejoinsel); ALTER OPERATOR > (ltree, ltree) SET (RESTRICT = scalargtsel, JOIN = scalargtjoinsel); ALTER OPERATOR @> (ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^@> (ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR <@ (ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^<@ (ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ~ (ltree, lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ~ (lquery, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^~ (ltree, lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^~ (lquery, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ? (ltree, _lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ? (_lquery, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^? (ltree, _lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^? (_lquery, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR @ (ltree, ltxtquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR @ (ltxtquery, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^@ (ltree, ltxtquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^@ (ltxtquery, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR @> (_ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR <@ (ltree, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR <@ (_ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR @> (ltree, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ~ (_ltree, lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ~ (lquery, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ? (_ltree, _lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ? (_lquery, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR @ (_ltree, ltxtquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR @ (ltxtquery, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^@> (_ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^<@ (ltree, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^<@ (_ltree, ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^@> (ltree, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^~ (_ltree, lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^~ (lquery, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^? (_ltree, _lquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^? (_lquery, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^@ (_ltree, ltxtquery) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); ALTER OPERATOR ^@ (ltxtquery, _ltree) SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);