Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kApMU-0006xJ-Lk for pgsql-docs@arkaria.postgresql.org; Wed, 26 Aug 2020 06:56:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kApMT-0006Ms-Im for pgsql-docs@arkaria.postgresql.org; Wed, 26 Aug 2020 06:56:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kApMR-0006Mk-Ec for pgsql-docs@lists.postgresql.org; Wed, 26 Aug 2020 06:56:45 +0000 Received: from [66.111.4.28] (helo=out4-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kApMM-0005dj-QJ for pgsql-docs@postgresql.org; Wed, 26 Aug 2020 06:56:42 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id EC0F45C0165; Wed, 26 Aug 2020 02:56:25 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Wed, 26 Aug 2020 02:56:25 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=09P4sagxSHCx0XcN1WM384YPkXz iFzCFh6w/6yZNV2g=; b=MpviQTeVk0/0SdIoHY5ElsbHLk8196o/2tFJlJtG7S8 amIH/gPbqI7ylakp+K8eqUB2pof4zcPJQ9gd1llh+BofDDRkxwK31TzaLwHXd6mw PHBWWs8wrfRg4skrf9zKbvXuLwwDLoauOW1mhXr/JpVkJ0CyFYXjAaBsjxm3gttY Cg+zZAUc9vsl5VdRU92kCplG6HZ7rbk77kKeDZfHkFlwMEiHzFWY0gZZ+Sh2ftrU wUWGRYtl3q6TteA6vhFWeBDoU35R4U07zJeBHcLlZ5WoYBrNxhWMWMk1R0vexYBj 35gZVkBEwMhTSebQ54/SSLdHuvjeFPdd1+Vh0LdVOVg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=09P4sa gxSHCx0XcN1WM384YPkXziFzCFh6w/6yZNV2g=; b=aCuII8CJdHyBV4BZQgjZUT o0vVutpGLhGdsRMxXgJsnIw0dTWza2JwcoNkR8mbs/n7KpWO2Xnw5lxvuExeTNVp aQ7AU8qPpT6XGmjctSc+rhMY7MhvCjRlBLSJp/BNZPf7itjXTasaxltuEt3pAFMY dIMRE4McoB/p8Sw6MOVKBgqZpf8x2pR695cICsbZhHjrnpL6Oew6ET90xhReTwSB 0de4FrI1ldb40gUbJewsC5nqcS0Rv+OlKkaxHjkeNcKrMHUma+q8WSa8Mo9xCwqi G+IekTVigsM7H75sNKLTe+lR5dYFxyyvz824kPx1VTqV4euPKVS/3QJ9jVeY7uoQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedruddvuddguddujecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enfghrlhcuvffnffculddvfedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepjeeugfeuhfdvjefgkeeukeej udetieejvdeileehfefggffhvdfhteeffeegleejnecuffhomhgrihhnpeguohgtsghooh hkrdhorhhgnecukfhppeduuddurddutddvrddukedtrddukeehnecuvehluhhsthgvrhfu ihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuih gvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 4F74C30600B2; Wed, 26 Aug 2020 02:56:22 -0400 (EDT) Date: Wed, 26 Aug 2020 15:56:18 +0900 From: Michael Paquier To: Tom Lane Cc: Alvaro Herrera , Bruce Momjian , osdba , pgsql-docs@postgresql.org Subject: Re: Document "59.2. Built-in Operator Classes" have a clerical error? Message-ID: <20200826065618.GG2017@paquier.xyz> References: <20200825221028.GA24594@alvherre.pgsql> <2770080.1598393848@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="PWfwoUCx3AFJRUBq" Content-Disposition: inline In-Reply-To: <2770080.1598393848@sss.pgh.pa.us> X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.28 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --PWfwoUCx3AFJRUBq Content-Type: multipart/mixed; boundary="k+G3HLlWI7eRTl+h" Content-Disposition: inline --k+G3HLlWI7eRTl+h Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Aug 25, 2020 at 06:17:28PM -0400, Tom Lane wrote: > Alvaro Herrera writes: >> (With the non-website stylesheet, as in the screenshot you showed, the >> table looks somewhat crammed and visually unappealing; but the website >> stylesheet looks pleasing enough. Screenshot attached.) Right, STYLE=3Dwebsite. > I wonder if it would look better if we suppress the horizontal rules > between the operator names within a cell. IIRC, it's possible to do > that, though the exact incantation isn't coming to mind right now. I would imagine that rowsep=3D0 for a given can do that: https://tdg.docbook.org/tdg/4.5/entry.html However, it does not make a difference if I use the default style or the website style. I may be missing something with the stylesheet though? >> I suppose a commit would change all the index AMs where we document this >> kind of thing. >=20 > Yeah, we should make all these sorts of tables consistent. Of course, just wanted to make sure that we agree on the layer before spending more time on that as shaping all the tables correctly is a lot of work. And GIN is the smallest one. One thing to note about the BRIN table is that we have never documented from the start any of the operators working across multiple types. For example, we only have 5 operators listed for each one of int2/int4/int8, timestamptz/timestamp or real/float, but these are listed with incorrect names and they miss a bunch of other operators able to handle combinations of (int2,int4), etc. So I have fixed the table so as all the operators are listed, grouping together ints, timestamps and reals, as \dAo says. Now there could be also an argument to stick with simplicity and list only the operators of one single type, reducing the size of the table for BRIN. But that would be incorrect with the catalogs, and the attached classifies all operators in alphabetical order. (Switching to the original list is not complicated as that would be just removing code from the attached, so I took the complicated path for now.) -- Michael --k+G3HLlWI7eRTl+h Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="doc-builtin-ops.patch" Content-Transfer-Encoding: quoted-printable diff --git a/doc/src/sgml/brin.sgml b/doc/src/sgml/brin.sgml index b9d596e3c4..341fe8e021 100644 --- a/doc/src/sgml/brin.sgml +++ b/doc/src/sgml/brin.sgml @@ -133,341 +133,357 @@ LOG: request for BRIN range summarization for inde= x "brin_wi_idx" page 128 was - int8_minmax_ops - bigint - - < - <=3D - =3D - >=3D - > - + bit_minmax_ops + bit + =3D(bit,bit) + <(bit,bit) + >(bit,bit) + <=3D(bit,bit) + >=3D(bit,bit) + =20 - bit_minmax_ops - bit - - < - <=3D - =3D - >=3D - > - + box_inclusion_ops + box + @>(box,point) + <<(box,box) + &<(box,box) + &>(box,box) + >>(box,box) + <@(box,box) + @>(box,box) + ~=3D(box,box) + &&(box,box) + <<|(box,box) + &<|(box,box) + |&>(box,box) + |>>(box,box) + =20 - varbit_minmax_ops - bit varying - - < - <=3D - =3D - >=3D - > - + bpchar_minmax_ops + character + =3D(character,character) + <(character,character) + <=3D(character,character) + >(character,character) + >=3D(character,character) + =20 - box_inclusion_ops - box - - << - &< - && - &> - >> - ~=3D - @> - <@ - &<| - <<| - |>> - |&> - + bytea_minmax_ops + bytea + =3D(bytea,bytea) + <(bytea,bytea) + <=3D(bytea,bytea) + >(bytea,bytea) + >=3D(bytea,bytea) + =20 - bytea_minmax_ops - bytea - - < - <=3D - =3D - >=3D - > - + char_minmax_ops + "char" + =3D("char","char") + <("char","char") + <=3D("char","char") + >("char","char") + >=3D("char","char") + =20 - bpchar_minmax_ops - character - - < - <=3D - =3D - >=3D - > - + datetime_minmax_ops + date, timestamp with time z= one, timestamp without time zone + =3D(date,date) + <(date,date) + <=3D(date,date) + >(date,date) + >=3D(date,date) + =3D(timestamp with time zone,timestamp with time = zone) + <(timestamp with time zone,timestamp with time= zone) + <=3D(timestamp with time zone,timestamp with t= ime zone) + >(timestamp with time zone,timestamp with time= zone) + >=3D(timestamp with time zone,timestamp with t= ime zone) + =3D(timestamp without time zone,timestamp without= time zone) + <(timestamp without time zone,timestamp withou= t time zone) + <=3D(timestamp without time zone,timestamp wit= hout time zone) + >(timestamp without time zone,timestamp withou= t time zone) + >=3D(timestamp without time zone,timestamp wit= hout time zone) + <(date,timestamp without time zone)<= /entry> + <=3D(date,timestamp without time zone) + =3D(date,timestamp without time zone) + >=3D(date,timestamp without time zone) + >(date,timestamp without time zone)<= /entry> + <(date,timestamp with time zone) + <=3D(date,timestamp with time zone)<= /entry> + =3D(date,timestamp with time zone) + >=3D(date,timestamp with time zone)<= /entry> + >(date,timestamp with time zone) + <(timestamp without time zone,date)<= /entry> + <=3D(timestamp without time zone,date) + =3D(timestamp without time zone,date) + >=3D(timestamp without time zone,date) + >(timestamp without time zone,date)<= /entry> + <(timestamp with time zone,date) + <=3D(timestamp with time zone,date)<= /entry> + =3D(timestamp with time zone,date) + >=3D(timestamp with time zone,date)<= /entry> + >(timestamp with time zone,date) + <(timestamp without time zone,timestamp with t= ime zone) + <=3D(timestamp without time zone,timestamp wit= h time zone) + =3D(timestamp without time zone,timestamp with ti= me zone) + >=3D(timestamp without time zone,timestamp wit= h time zone) + >(timestamp without time zone,timestamp with t= ime zone) + <(timestamp with time zone,timestamp without t= ime zone) + <=3D(timestamp with time zone,timestamp withou= t time zone) + =3D(timestamp with time zone,timestamp without ti= me zone) + >=3D(timestamp with time zone,timestamp withou= t time zone) + >(timestamp with time zone,timestamp without t= ime zone) + =20 - char_minmax_ops - "char" - - < - <=3D - =3D - >=3D - > - + float_minmax_ops + double precision, real + =3D(real,real) + <(real,real) + >(real,real) + <=3D(real,real) + >=3D(real,real) + =3D(double precision,double precision)<= /entry> + <(double precision,double precision)= + <=3D(double precision,double precision) + >(double precision,double precision)= + >=3D(double precision,double precision) + =3D(real,double precision) + <(real,double precision) + >(real,double precision) + <=3D(real,double precision)<= /row> + >=3D(real,double precision)<= /row> + =3D(double precision,real) + <(double precision,real) + >(double precision,real) + <=3D(double precision,real)<= /row> + >=3D(double precision,real)<= /row> + =20 - date_minmax_ops - date - - < - <=3D - =3D - >=3D - > - + integer_minmax_ops + smallint, integer, <= type>bigint + =3D(integer,bigint) + <(integer,bigint) + >(integer,bigint) + <=3D(integer,bigint) + >=3D(integer,bigint) + =3D(smallint,smallint) + <(smallint,smallint) + =3D(integer,integer) + <(integer,integer) + =3D(bigint,bigint) + <(bigint,bigint) + >(bigint,bigint) + <=3D(bigint,bigint) + >=3D(bigint,bigint) + =3D(bigint,integer) + <(bigint,integer) + >(bigint,integer) + <=3D(bigint,integer) + >=3D(bigint,integer) + >(smallint,smallint) + >(integer,integer) + <=3D(smallint,smallint) + <=3D(integer,integer) + >=3D(smallint,smallint) + >=3D(integer,integer) + =3D(smallint,integer) + =3D(integer,smallint) + <(smallint,integer) + <(integer,smallint) + >(smallint,integer) + >(integer,smallint) + <=3D(smallint,integer) + <=3D(integer,smallint) + >=3D(smallint,integer) + >=3D(integer,smallint) + =3D(smallint,bigint) + <(smallint,bigint) + >(smallint,bigint) + <=3D(smallint,bigint) + >=3D(smallint,bigint) + =3D(bigint,smallint) + <(bigint,smallint) + >(bigint,smallint) + <=3D(bigint,smallint) + >=3D(bigint,smallint) + =20 - float8_minmax_ops - double precision - - < - <=3D - =3D - >=3D - > - + interval_minmax_ops + interval + =3D(interval,interval) + <(interval,interval) + <=3D(interval,interval) + >(interval,interval) + >=3D(interval,interval) + =20 - inet_minmax_ops - inet - - < - <=3D - =3D - >=3D - > - + maxaddr8_minmax_ops + macaddr8 + =3D(macaddr8,macaddr8) + <(macaddr8,macaddr8) + <=3D(macaddr8,macaddr8) + >(macaddr8,macaddr8) + >=3D(macaddr8,macaddr8) + =20 - network_inclusion_ops - inet - - && - >>=3D - <<=3D - =3D - >> - << - + maxaddr_minmax_ops + macaddr + =3D(macaddr,macaddr) + <(macaddr,macaddr) + <=3D(macaddr,macaddr) + >(macaddr,macaddr) + >=3D(macaddr,macaddr) + =20 - int4_minmax_ops - integer - - < - <=3D - =3D - >=3D - > - + name_minmax_ops + name + =3D(name,name) + <(name,name) + <=3D(name,name) + >(name,name) + >=3D(name,name) + =20 - interval_minmax_ops - interval - - < - <=3D - =3D - >=3D - > - + network_inclusion_ops + inet + <<(inet,inet) + <<=3D(inet,inet) + >>(inet,inet) + >>=3D(inet,inet) + =3D(inet,inet) + &&(inet,inet) + =20 - macaddr_minmax_ops - macaddr - - < - <=3D - =3D - >=3D - > - + network_minmax_ops + inet + =3D(inet,inet) + <(inet,inet) + <=3D(inet,inet) + >(inet,inet) + >=3D(inet,inet) + =20 - macaddr8_minmax_ops - macaddr8 - - < - <=3D - =3D - >=3D - > - + numeric_minmax_ops + numeric + =3D(numeric,numeric) + <(numeric,numeric) + <=3D(numeric,numeric) + >(numeric,numeric) + >=3D(numeric,numeric) + =20 - name_minmax_ops - name - - < - <=3D - =3D - >=3D - > - + oid_minmax_ops + oid + =3D(oid,oid) + <(oid,oid) + >(oid,oid) + <=3D(oid,oid) + >=3D(oid,oid) + =20 - numeric_minmax_ops - numeric - - < - <=3D - =3D - >=3D - > - + pg_lsn_minmax_ops + pg_lsn + =3D(pg_lsn,pg_lsn) + <(pg_lsn,pg_lsn) + >(pg_lsn,pg_lsn) + <=3D(pg_lsn,pg_lsn) + >=3D(pg_lsn,pg_lsn) + =20 - pg_lsn_minmax_ops - pg_lsn - - < - <=3D - =3D - >=3D - > - + range_inclusion_ops + any range type + =3D(anyrange,anyrange) + <(anyrange,anyrange) + <=3D(anyrange,anyrange) + >=3D(anyrange,anyrange) + >(anyrange,anyrange) + &&(anyrange,anyrange) + @>(anyrange,anyelement) + @>(anyrange,anyrange) + <@(anyrange,anyrange) + <<(anyrange,anyrange) + >>(anyrange,anyrange) + &<(anyrange,anyrange) + &>(anyrange,anyrange) + -|-(anyrange,anyrange) + =20 - oid_minmax_ops - oid - - < - <=3D - =3D - >=3D - > - + text_minmax_ops + text + =3D(text,text) + <(text,text) + <=3D(text,text) + >(text,text) + >=3D(text,text) + =20 - range_inclusion_ops - any range type - - << - &< - && - &> - >> - @> - <@ - -|- - =3D - < - <=3D - =3D - > - >=3D - + tid_minmax_ops + tid + =3D(tid,tid) + <(tid,tid) + >(tid,tid) + <=3D(tid,tid) + >=3D(tid,tid) + =20 - float4_minmax_ops - real - - < - <=3D - =3D - >=3D - > - + time_minmax_ops + time without time zone + =3D(time without time zone,time without time zone) + <(time without time zone,time without time zon= e) + <=3D(time without time zone,time without time = zone) + >(time without time zone,time without time zon= e) + >=3D(time without time zone,time without time = zone) + =20 - int2_minmax_ops - smallint - - < - <=3D - =3D - >=3D - > - + timetz_minmax_ops + time with time zone + =3D(time with time zone,time with time zone) + <(time with time zone,time with time zone) + <=3D(time with time zone,time with time zone)<= /literal> + >(time with time zone,time with time zone) + >=3D(time with time zone,time with time zone)<= /literal> + =20 - text_minmax_ops - text - - < - <=3D - =3D - >=3D - > - + uuid_minmax_ops + uuid + =3D(uuid,uuid) + <(uuid,uuid) + >(uuid,uuid) + <=3D(uuid,uuid) + >=3D(uuid,uuid) + =20 - tid_minmax_ops - tid - - < - <=3D - =3D - >=3D - > - - - - timestamp_minmax_ops - timestamp without time zone - - < - <=3D - =3D - >=3D - > - - - - timestamptz_minmax_ops - timestamp with time zone - - < - <=3D - =3D - >=3D - > - - - - time_minmax_ops - time without time zone - - < - <=3D - =3D - >=3D - > - - - - timetz_minmax_ops - time with time zone - - < - <=3D - =3D - >=3D - > - - - - uuid_minmax_ops - uuid - - < - <=3D - =3D - >=3D - > - + varbit_minmax_ops + varbit + =3D(bit varying,bit varying) + <(bit varying,bit varying) + >(bit varying,bit varying) + <=3D(bit varying,bit varying) + >=3D(bit varying,bit varying) diff --git a/doc/src/sgml/gin.sgml b/doc/src/sgml/gin.sgml index 2d862669c3..6fee0280be 100644 --- a/doc/src/sgml/gin.sgml +++ b/doc/src/sgml/gin.sgml @@ -85,43 +85,57 @@ - array_ops - anyarray - - && - <@ - =3D - @> - + array_ops + anyarray + &&(anyarray,anyarray) - jsonb_ops - jsonb - - ? - ?& - ?| - @> - @? - @@ - + @>(anyarray,anyarray) - jsonb_path_ops - jsonb - - @> - @? - @@ - + <@(anyarray,anyarray) - tsvector_ops - tsvector - - @@ - @@@ - + =3D(anyarray,anyarray) + + + jsonb_ops + jsonb + @>(jsonb,jsonb) + + + @?(jsonb,jsonpath) + + + @@(jsonb,jsonpath) + + + ?(jsonb,text) + + + ?|(jsonb,text[]) + + + ?&(jsonb,text[]) + + + jsonb_path_ops + jsonb + @>(jsonb,jsonb) + + + @?(jsonb,jsonpath) + + + @@(jsonb,jsonpath) + + + tsvector_ops + tsvector + @@(tsvector,tsquery) + + + @@@(tsvector,tsquery) diff --git a/doc/src/sgml/gist.sgml b/doc/src/sgml/gist.sgml index a505815f4e..0637077f6f 100644 --- a/doc/src/sgml/gist.sgml +++ b/doc/src/sgml/gist.sgml @@ -64,146 +64,119 @@ - box_ops - box - - && - &> - &< - &<| - >> - << - <<| - <@ - @> - @ - |&> - |>> - ~ - ~=3D - - - <-> - + box_ops + box + <<(box,box) + <->(box,point) + &<(box,box) + &&(box,box) + &>(box,box) + >>(box,box) + ~=3D(box,box) + @>(box,box) + <@(box,box) + &<|(box,box) + <<|(box,box) + |>>(box,box) + |&>(box,box) + ~(box,box) + @(box,box) - circle_ops - circle - - && - &> - &< - &<| - >> - << - <<| - <@ - @> - @ - |&> - |>> - ~ - ~=3D - - - <-> - + circle_ops + circle + <<(circle,circle) + <->(circle,point) + &<(circle,circle) + &>(circle,circle) + >>(circle,circle) + <@(circle,circle) + @>(circle,circle) + ~=3D(circle,circle) + &&(circle,circle) + |>>(circle,circle) + <<|(circle,circle) + &<|(circle,circle) + |&>(circle,circle) + @(circle,circle) + ~(circle,circle) - inet_ops - inet, cidr - - && - >> - >>=3D - > - >=3D - <> - << - <<=3D - < - <=3D - =3D - - - + inet_ops + inet, cidr + <<(inet,inet) + + <<=3D(inet,inet) + >>(inet,inet) + >>=3D(inet,inet) + =3D(inet,inet) + <>(inet,inet) + <(inet,inet) + <=3D(inet,inet) + >(inet,inet) + >=3D(inet,inet) + &&(inet,inet) - point_ops - point - - >> - >^ - << - <@ - <@ - <@ - <^ - ~=3D - - - <-> - + point_ops + point + >^(point,point) + <->(point,point) + <<(point,point) + >>(point,point) + <^(point,point) + ~=3D(point,point) + <@(point,box) + <@(point,polygon) + <@(point,circle) - poly_ops - polygon - - && - &> - &< - &<| - >> - << - <<| - <@ - @> - @ - |&> - |>> - ~ - ~=3D - - - <-> - + poly_ops + polygon + <<(polygon,polygon) + <->(polygon,point) + &<(polygon,polygon) + &>(polygon,polygon) + >>(polygon,polygon) + <@(polygon,polygon) + @>(polygon,polygon) + ~=3D(polygon,polygon) + &&(polygon,polygon) + <<|(polygon,polygon) + &<|(polygon,polygon) + |&>(polygon,polygon) + |>>(polygon,polygon) + @(polygon,polygon) + ~(polygon,polygon) + <->(polygon,point) - range_ops - any range type - - && - &> - &< - >> - << - <@ - -|- - =3D - @> - @> - - - + range_ops + any range type + =3D(anyrange,anyrange) + + &&(anyrange,anyrange)<= /row> + @>(anyrange,anyelement) + @>(anyrange,anyrange) + <@(anyrange,anyrange) + <<(anyrange,anyrange) + >>(anyrange,anyrange) + &<(anyrange,anyrange) + &>(anyrange,anyrange) + -|-(anyrange,anyrange) - tsquery_ops - tsquery - - <@ - @> - - - + tsquery_ops + tsquery + <@(tsquery,tsquery) + + @>(tsquery,tsquery) tsvector_ops tsvector - - @@ - - - + @@(tsvector,tsquery) + diff --git a/doc/src/sgml/spgist.sgml b/doc/src/sgml/spgist.sgml index b86302e4ef..5d45ef81e0 100644 --- a/doc/src/sgml/spgist.sgml +++ b/doc/src/sgml/spgist.sgml @@ -75,131 +75,113 @@ - kd_point_ops - point - - << - <@ - <^ - >> - >^ - ~=3D - - - <-> - + box_ops + box + <<(box,box) + <->(box,point) =20 + &<(box,box) + &>(box,box) + >>(box,box) + <@(box,box) + @>(box,box) + ~=3D(box,box) + &&(box,box) + <<|(box,box) + &<|(box,box) + |&>(box,box) + |>>(box,box) + - quad_point_ops - point - - << - <@ - <^ - >> - >^ - ~=3D - - - <-> - + kd_point_ops + point + >^(point,point) + <->(point,point) + <<(point,point) + >>(point,point) + <^(point,point) + ~=3D(point,point) + <@(point,box) + - range_ops - any range type - - && - &< - &> - -|- - << - <@ - =3D - >> - @> - - - + network_ops + inet, cidr + <<(inet,inet) + + <<=3D(inet,inet) + >>(inet,inet) + >>=3D(inet,inet) + =3D(inet,inet) + <>(inet,inet) + <(inet,inet) + <=3D(inet,inet) + >(inet,inet) + >=3D(inet,inet) + &&(inet,inet) + - box_ops - box - - << - &< - && - &> - >> - ~=3D - @> - <@ - &<| - <<| - |>> - |&> - - - <-> - + poly_ops + polygon + <<(polygon,polygon) + <->(polygon,point) + &<(polygon,polygon) + &>(polygon,polygon) + >>(polygon,polygon) + <@(polygon,polygon) + @>(polygon,polygon) + ~=3D(polygon,polygon) + &&(polygon,polygon) + <<|(polygon,polygon) + &<|(polygon,polygon) + |>>(polygon,polygon) + |&>(polygon,polygon) =20 + - poly_ops - polygon - - << - &< - && - &> - >> - ~=3D - @> - <@ - &<| - <<| - |>> - |&> - - - <-> - + quad_point_ops + point + >^(point,point) + <->(point,point) + <<(point,point) + >>(point,point) + <^(point,point) + ~=3D(point,point) + <@(point,box) + - text_ops - text - - < - <=3D - =3D - > - >=3D - ~<=3D~ - ~<~ - ~>=3D~ - ~>~ - ^@ - - - + range_ops + any range type + =3D(anyrange,anyrange) + + &&(anyrange,anyrange)<= /row> + @>(anyrange,anyelement) + @>(anyrange,anyrange) + <@(anyrange,anyrange) + <<(anyrange,anyrange) + >>(anyrange,anyrange) + &<(anyrange,anyrange) + &>(anyrange,anyrange) + -|-(anyrange,anyrange) +=20 - inet_ops - inet, cidr - - && - >> - >>=3D - > - >=3D - <> - << - <<=3D - < - <=3D - =3D - - - + text_ops + text + =3D(text,text) + + <(text,text) + <=3D(text,text) + >(text,text) + >=3D(text,text) + ~<~(text,text) + ~<=3D~(text,text) + ~>=3D~(text,text) + ~>~(text,text) + ^@(text,text) --k+G3HLlWI7eRTl+h-- --PWfwoUCx3AFJRUBq Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl9GB5IACgkQnvQgOdby QH2d3A//V7rI7VLem+ZkxFkN10ZCdHW0PfcIO1R3E1NWShrucFmVQ86uf5hpDBDw mVFJJW2xvq+jb+ZA1ZuwRSyEutcaP2+7DJqQUVLzMmtPVHgRVtz+lZ5L6NJonc6k JLil6cXhyZQNXvDJV6leRGcMfESOd+JrhHqeANCRSVf+eXspYAs425H9JeCxwvkB qIWGU1EY8LJL/ZYUy/v+JW/OnqrNxwxU1OVCkBeRmncGsOC4lTIB2rt6PxDkrwDp PEsOaoQ3Iyehj7AwGdgPJWm86HaVkMOGwYAApYllpqnM0AwRE/wHMYD1qs1zyi7k KgcVKfhvIGJcJofZTjGMnJEa/h/C6//toGQP69lJMl2MgoTmHlf27wG1Ph7V3qao T5vr4CaFVLImb8D+BcSwSlkW+DkBpNaLBrJB0sjieGpC9iZjQ64WimQOp+OgGY8A Pkx1SouD4w1A8sJTm41LnBMT3qlJnPuN3K0OC7rQdOb7I9RKt6GrH4NaOQU7gYy8 PEU8MRDJnElSPg1FvtYiX1WNeJ58iSoerW/JsVkJxvQDFcwW5LsIOz1LABqw3/0c 2XU7el3/IZW3U3+Lx6cCe5wnPX7b71srR75mqxfK/RTF1+JsePt5n51uS9iWbGa7 iXqHR/vuU78i7hfms0bSJjno2u4KRS70qb1UkPQU3NqrmmJNByM= =D795 -----END PGP SIGNATURE----- --PWfwoUCx3AFJRUBq--