FilesExpand file tree

main

/

15_CodeWars.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

24 lines (13 loc) · 605 Bytes

main

/

15_CodeWars.sql

Copy path

Top

File metadata and controls

• Code
• Blame

24 lines (13 loc) · 605 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

-- QUESTION

-- For this challenge you need to create a basic Increment function which Increments on the age field of the peoples table.

-- The function should be called increment, it needs to take 1 integer and increment that number by 1.

-- You may query the people table while testing but the query must only contain the function on your final submit.

-- important: you must remove all comments when submitting the kata.

-- people table schema

-- id

-- name

--age

-- SOLUTION

CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer

AS $$ BEGIN RETURN i + 1; END; $$

LANGUAGE plpgsql;