How select data in postgresql using ' where' array string element from jsonb fields?

Question

i have table like above . i want to select the pengumuman field from table using one of element in array from office field . SELECT pengumuman from pengumuman_table where officee ... and i don't know what the next to get data from array with element BWI . how fix that query ? .thanks for your replay

GMB · Accepted Answer · 2020-12-26 01:12:54Z

2

If you want to search the array for a specific value, use any():

select pengumuman
from pengumuman_table
where $1 = any(office)

$1 is the parameter to the query, a literal string to search for in the text arrays.

answered Dec 26, 2020 at 1:12

GMB

224k25 gold badges103 silver badges151 bronze badges

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

2 Comments

silvester landu hunggu wali Over a year ago

hi thank's for your replay ..when i try that query i got ``` SQL Error [42703]: ERROR: column "bwi" does not exist¶ Position: 39```

GMB Over a year ago

@silvesterlanduhungguwali: there is no bwi in this query. You would need to figure out what the correct column names are...

Collectives™ on Stack Overflow

How select data in postgresql using ' where' array string element from jsonb fields?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related