NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit7539a1b

committed

doc: clarify handling of range upper/lower/upper_inf/lower_inf()

Clarify handling of infinite range bounds.Reported-by: jani.rahkola@iki.fiDiscussion:https://postgr.es/m/160508672127.25505.8356390205508789564@wrigleys.postgresql.orgCo-authored-by: Laurenz AlbeBackpatch-through: 16

1 parentd1379eb commit7539a1bCopy full SHA for 7539a1b

File tree

1 file changed

+12

-8

lines changed

doc/src/sgml
- func.sgml

1 file changed

+12

-8

lines changed

`‎doc/src/sgml/func.sgml`

Lines changed: 12 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -19963,7 +19963,7 @@ SELECT NULLIF(value, '(none)') ...`
`19963`	`19963`	`</para>`
`19964`	`19964`	`<para>`
`19965`	`19965`	`Extracts the lower bound of the range (<literal>NULL</literal> if the`
`19966`		`- range is empty orthelower bound is infinite).`
	`19966`	`+ range is empty orhas nolower bound).`
`19967`	`19967`	`</para>`
`19968`	`19968`	`<para>`
`19969`	`19969`	`<literal>lower(numrange(1.1,2.2))</literal>`
`@@ -19981,7 +19981,7 @@ SELECT NULLIF(value, '(none)') ...`
`19981`	`19981`	`</para>`
`19982`	`19982`	`<para>`
`19983`	`19983`	`Extracts the upper bound of the range (<literal>NULL</literal> if the`
`19984`		`- range is empty ortheupper bound is infinite).`
	`19984`	`+ range is empty orhas noupper bound).`
`19985`	`19985`	`</para>`
`19986`	`19986`	`<para>`
`19987`	`19987`	`<literal>upper(numrange(1.1,2.2))</literal>`
`@@ -20049,7 +20049,8 @@ SELECT NULLIF(value, '(none)') ...`
`20049`	`20049`	`<returnvalue>boolean</returnvalue>`
`20050`	`20050`	`</para>`
`20051`	`20051`	`<para>`
`20052`		`- Is the range's lower bound infinite?`
	`20052`	`+ Does the range have no lower bound? (A lower bound of`
	`20053`	`+ <literal>-Infinity</literal> returns false.)`
`20053`	`20054`	`</para>`
`20054`	`20055`	`<para>`
`20055`	`20056`	`<literal>lower_inf('(,)'::daterange)</literal>`
`@@ -20066,7 +20067,8 @@ SELECT NULLIF(value, '(none)') ...`
`20066`	`20067`	`<returnvalue>boolean</returnvalue>`
`20067`	`20068`	`</para>`
`20068`	`20069`	`<para>`
`20069`		`- Is the range's upper bound infinite?`
	`20070`	`+ Does the range have no upper bound? (An upper bound of`
	`20071`	`+ <literal>Infinity</literal> returns false.)`
`20070`	`20072`	`</para>`
`20071`	`20073`	`<para>`
`20072`	`20074`	`<literal>upper_inf('(,)'::daterange)</literal>`
`@@ -20121,7 +20123,7 @@ SELECT NULLIF(value, '(none)') ...`
`20121`	`20123`	`</para>`
`20122`	`20124`	`<para>`
`20123`	`20125`	`Extracts the lower bound of the multirange (<literal>NULL</literal> if the`
`20124`		`- multirange is emptyor the lower bound is infinite).`
	`20126`	`+ multirange is emptyhas no lower bound).`
`20125`	`20127`	`</para>`
`20126`	`20128`	`<para>`
`20127`	`20129`	`<literal>lower('{[1.1,2.2)}'::nummultirange)</literal>`
`@@ -20139,7 +20141,7 @@ SELECT NULLIF(value, '(none)') ...`
`20139`	`20141`	`</para>`
`20140`	`20142`	`<para>`
`20141`	`20143`	`Extracts the upper bound of the multirange (<literal>NULL</literal> if the`
`20142`		`- multirange is empty ortheupper bound is infinite).`
	`20144`	`+ multirange is empty orhas noupper bound).`
`20143`	`20145`	`</para>`
`20144`	`20146`	`<para>`
`20145`	`20147`	`<literal>upper('{[1.1,2.2)}'::nummultirange)</literal>`
`@@ -20207,7 +20209,8 @@ SELECT NULLIF(value, '(none)') ...`
`20207`	`20209`	`<returnvalue>boolean</returnvalue>`
`20208`	`20210`	`</para>`
`20209`	`20211`	`<para>`
`20210`		`- Is the multirange's lower bound infinite?`
	`20212`	`+ Does the multirange have no lower bound? (A lower bound of`
	`20213`	`+ <literal>-Infinity</literal> returns false.)`
`20211`	`20214`	`</para>`
`20212`	`20215`	`<para>`
`20213`	`20216`	`<literal>lower_inf('{(,)}'::datemultirange)</literal>`
`@@ -20224,7 +20227,8 @@ SELECT NULLIF(value, '(none)') ...`
`20224`	`20227`	`<returnvalue>boolean</returnvalue>`
`20225`	`20228`	`</para>`
`20226`	`20229`	`<para>`
`20227`		`- Is the multirange's upper bound infinite?`
	`20230`	`+ Does the multirange have no upper bound? (An upper bound of`
	`20231`	`+ <literal>Infinity</literal> returns false.)`
`20228`	`20232`	`</para>`
`20229`	`20233`	`<para>`
`20230`	`20234`	`<literal>upper_inf('{(,)}'::datemultirange)</literal>`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit7539a1b

File tree

1 file changed

1 file changed

`‎doc/src/sgml/func.sgml`

0 commit comments