Calling a function which has a numeric value assigned to it for query

Question

Here instead of using 7 days interval, I want to use days_gap in a function and pass a numeric value to it instead of a hardcoded value. And then directly call it in the SELECT function

SELECT BOO_NUMBER,
      ROO_NUMBER
    FROM BOO B
    WHERE B.FOO < CURRENT_TIMESTAP - '7 days'::interval

Instead of using '7 days'::interval I want to use a function days_gap which takes a numeric value in the function and can be called respectively instead of 7 days interval.

Please help me with the function code to be called in the select query.

Thanks in advance!

Georgi Raychev · Accepted Answer · 2019-04-18 08:31:40Z

1

This should do:

SELECT BOO_NUMBER,
      ROO_NUMBER
    FROM BOO B
    WHERE B.FOO < CURRENT_TIMESTAP - interval '1 day' * days_gap()

answered Apr 18, 2019 at 8:31

Georgi Raychev

1,3441 gold badge13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

champ.exe Over a year ago

I need a code for days_gap() which takes a number.

user330315 · Accepted Answer · 2019-04-18 08:47:24Z

0

Are you looking for make_interval()?

SELECT boo_number,
       roo_number
FROM boo b
WHERE b.foo < current_timestap - make_interval(days => 7);

Note that you can always multiply a one day interval with the desired number of days as well:

interval '1 day' * 7 is the same as interval '7 day'

answered Apr 18, 2019 at 8:47

user330315

Collectives™ on Stack Overflow

Calling a function which has a numeric value assigned to it for query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related