Commit2ddac94

committed

Add documentation example of using interval multiplication with 'days'.

Backpatch to 8.1.X.

1 parent3086f6e commit2ddac94Copy full SHA for 2ddac94

File tree

-1

lines changed

-1

lines changed

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.299 2005/12/2116:02:24 momjian Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.300 2005/12/2123:22:55 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -5207,6 +5207,12 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');`
`5207`	`5207`	`<entry><literal>interval '00:15:00'</literal></entry>`
`5208`	`5208`	`</row>`
`5209`	`5209`
	`5210`	`+ <row>`
	`5211`	`+ <entry> <literal>*</literal> </entry>`
	`5212`	`+ <entry><literal>21 * interval '1 day'</literal></entry>`
	`5213`	`+ <entry><literal>interval '21 days'</literal></entry>`
	`5214`	`+ </row>`
	`5215`	`+`
`5210`	`5216`	`<row>`
`5211`	`5217`	`<entry> <literal>*</literal> </entry>`
`5212`	`5218`	`<entry><literal>double precision '3.5' * interval '1 hour'</literal></entry>`

Comments

(0)