postgres sql

[misty hollow]

I have a list of ints.

In the db I will have 3 columns

id - int
name - string
arr - array

I need to write a query where it checks if arr has any element from the list, then it should return the matched element and id.

For example
If the list has 4, 5

id 4
Name abc
arr [3, 4,5,6]

then it should return

id arr
4 4
4 5

[nimble flame]

<@&987246584574140416> please have a look, thanks.

[pliant agate]

In postgres we have unset() which will expand arrays into rows.

[nimble flame]

@misty hollow

Your question has been closed due to inactivity.

If it was not resolved yet, feel free to just post a message below
to reopen it, or create a new thread.

Note that usually the reason for nobody calling back is that your
question may have been not well asked and hence no one felt confident
enough answering.

When you reopen the thread, try to use your time to improve the quality
of the question by elaborating, providing details, context, all relevant code
snippets, any errors you are getting, concrete examples and perhaps also some
screenshots. Share your attempt, explain the expected results and compare
them to the current results.

Also try to make the information easily accessible by sharing code
or assignment descriptions directly on Discord, not behind a link or
PDF-file; provide some guidance for long code snippets and ensure
the code is well formatted and has syntax highlighting. Kindly read through
https://stackoverflow.com/help/how-to-ask for more.

With enough info, someone knows the answer for sure 👍

[misty hollow]

Thanks @pliant agate

Unset is working for my case.

I forgot to close the thread