Commit8fc719d

committed

pathman: documentation fix

1 parent3e6cf13 commit8fc719dCopy full SHA for 8fc719d

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -135,7 +135,7 @@ Consider an example of RANGE partitioning. Create a table with numerical or date`
`135`	`135`	`CREATE TABLE range_rel (`
`136`	`136`	`id SERIAL PRIMARY KEY,`
`137`	`137`	`dt TIMESTAMP);`
`138`		`-INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2015-12-31'::date, '1 day') as g;`
	`138`	`+INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2014-12-31'::date, '1 day') as g;`
`139`	`139`	```
`140`	`140`	`Run create_range_partitions() function to create partitions so that each partition would contain data for one month:`
`141`	`141`	```
`@@ -153,7 +153,7 @@ To split partition use split_range_partition() function:`
`153`	`153`	```
`154`	`154`	`SELECT split_range_partition('range_rel_1', '2010-02-15'::date);`
`155`	`155`	```
`156`		`-Now let's create newpartitions. You can use append_partition() or prepend_partition() functions:`
	`156`	`+Now let's create newpartition. You can use append_partition() or prepend_partition() functions:`
`157`	`157`	```
`158`	`158`	`SELECT append_partition('range_rel');`
`159`	`159`	`SELECT prepend_partition('range_rel');`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -137,7 +137,7 @@ SELECT partition_data('hash_rel');`
`137`	`137`	`CREATE TABLE range_rel (`
`138`	`138`	`id SERIAL PRIMARY KEY,`
`139`	`139`	`dt TIMESTAMP);`
`140`		`-INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2015-12-31'::date, '1 day') as g;`
	`140`	`+INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2014-12-31'::date, '1 day') as g;`
`141`	`141`	```
`142`	`142`	`Разобьем таблицу на 60 секций так, чтобы каждая секция содержала данные за один месяц:`
`143`	`143`	```

Comments

(0)