Commita4007c0

committed

Update for test changes.

1 parent16cc537 commita4007c0Copy full SHA for a4007c0

File tree

+68

-2

lines changed

+68

-2

lines changed

Lines changed: 34 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -149,13 +149,46 @@ SELECT '' AS five, f.f1, f.f1 % AS round_f1`
`149`	`149`	`\| 1.2345678901234e-200 \| 0`
`150`	`150`	`(5 rows)`
`151`	`151`
	`152`	`+-- ceil`
	`153`	`+select ceil(f1) as ceil_f1 from float8_tbl f;`
	`154`	`+ ceil_f1`
	`155`	`+----------------------`
	`156`	`+ 0`
	`157`	`+ 1005`
	`158`	`+ -34`
	`159`	`+ 1.2345678901234e+200`
	`160`	`+ 1`
	`161`	`+(5 rows)`
	`162`	`+`
	`163`	`+-- floor`
	`164`	`+select floor(f1) as floor_f1 from float8_tbl f;`
	`165`	`+ floor_f1`
	`166`	`+----------------------`
	`167`	`+ 0`
	`168`	`+ 1004`
	`169`	`+ -35`
	`170`	`+ 1.2345678901234e+200`
	`171`	`+ 0`
	`172`	`+(5 rows)`
	`173`	`+`
	`174`	`+-- sign`
	`175`	`+select sign(f1) as sign_f1 from float8_tbl f;`
	`176`	`+ sign_f1`
	`177`	`+---------`
	`178`	`+ 0`
	`179`	`+ 1`
	`180`	`+ -1`
	`181`	`+ 1`
	`182`	`+ 1`
	`183`	`+(5 rows)`
	`184`	`+`
	`185`	`+-- square root`
`152`	`186`	`SELECT sqrt(float8 '64') AS eight;`
`153`	`187`	`eight`
`154`	`188`	`-------`
`155`	`189`	`8`
`156`	`190`	`(1 row)`
`157`	`191`
`158`		`--- square root`
`159`	`192`	`SELECT \|/ float8 '64' AS eight;`
`160`	`193`	`eight`
`161`	`194`	`-------`

Lines changed: 34 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -149,13 +149,46 @@ SELECT '' AS five, f.f1, f.f1 % AS round_f1`
`149`	`149`	`\| 1.2345678901234e-200 \| 0`
`150`	`150`	`(5 rows)`
`151`	`151`
	`152`	`+-- ceil`
	`153`	`+select ceil(f1) as ceil_f1 from float8_tbl f;`
	`154`	`+ ceil_f1`
	`155`	`+----------------------`
	`156`	`+ 0`
	`157`	`+ 1005`
	`158`	`+ -34`
	`159`	`+ 1.2345678901234e+200`
	`160`	`+ 1`
	`161`	`+(5 rows)`
	`162`	`+`
	`163`	`+-- floor`
	`164`	`+select floor(f1) as floor_f1 from float8_tbl f;`
	`165`	`+ floor_f1`
	`166`	`+----------------------`
	`167`	`+ 0`
	`168`	`+ 1004`
	`169`	`+ -35`
	`170`	`+ 1.2345678901234e+200`
	`171`	`+ 0`
	`172`	`+(5 rows)`
	`173`	`+`
	`174`	`+-- sign`
	`175`	`+select sign(f1) as sign_f1 from float8_tbl f;`
	`176`	`+ sign_f1`
	`177`	`+---------`
	`178`	`+ 0`
	`179`	`+ 1`
	`180`	`+ -1`
	`181`	`+ 1`
	`182`	`+ 1`
	`183`	`+(5 rows)`
	`184`	`+`
	`185`	`+-- square root`
`152`	`186`	`SELECT sqrt(float8 '64') AS eight;`
`153`	`187`	`eight`
`154`	`188`	`-------`
`155`	`189`	`8`
`156`	`190`	`(1 row)`
`157`	`191`
`158`		`--- square root`
`159`	`192`	`SELECT \|/ float8 '64' AS eight;`
`160`	`193`	`eight`
`161`	`194`	`-------`

Comments

(0)