Find a range into an sql array

Question

How to find a matching range based on a given value x

For example, in column A, we have the value: {15-17,18-20,21-23}

The output expected for the x=16 should be 15-17 or x=21 should be 21-23

Any idea of the best way to achieve that ?

What data type is that column?

user330315
– user330315

2023-01-09 13:23:10 +00:00
Commented Jan 9, 2023 at 13:23 — user330315
– user330315, Commented Jan 9, 2023 at 13:23
It is a string type

JaMes
– JaMes

2023-01-09 13:27:15 +00:00
Commented Jan 9, 2023 at 13:27 — JaMes
– JaMes, Commented Jan 9, 2023 at 13:27
i think you should make a iteration on your string ;)

lili pupu
– lili pupu

2023-01-09 13:32:21 +00:00
Commented Jan 9, 2023 at 13:32 — lili pupu
– lili pupu, Commented Jan 9, 2023 at 13:32

Stefanov.sm · Accepted Answer · 2023-01-09 13:53:24Z

1

Try

select rangetext 
from unnest('{15-17,18-20,21-23}'::text[]) as t(rangetext)
where 16 between split_part(rangetext , '-', 1)::integer 
             and split_part(rangetext , '-', 2)::integer;

edited Jan 9, 2023 at 13:53

answered Jan 9, 2023 at 13:49

Stefanov.sm

13.2k2 gold badges24 silver badges24 bronze badges

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

1 Comment

JaMes Over a year ago

Top thanks, I'll try that immediately !!

Collectives™ on Stack Overflow

Find a range into an sql array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related