[TAJO-350] Implement round, floor, ceil

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Function/UDF
• Assignee: Hyoungjun Kim
• Reporter: Hyoungjun Kim
• Created: 01/Dec/13 06:15
• Updated: 01/Dec/13 09:43
• Resolved: 01/Dec/13 09:41

Description

Function Definition

INT8 round(value FLOAT8)
INT8 floor(value FLOAT8)
INT8 ceil(value FLOAT8)

Example

round

select round(5.1) => 5
select round(5.5) => 6
select round(5.6) => 6
select round(-5.1) => -5
select round(-5.5) => -6
select round(-5.6) => -6

floor

select round(5.1) => 5
select round(5.5) => 5
select round(-5.1) => -6
select round(-5.6) => -6

ceil

select round(5.1) => 6
select round(5.5) => 6
select round(-5.1) => -5
select round(-5.6) => -5