Sfrgttk

Difference between shutdown options

How do I Interface a PS/2 Keyboard without Modern Techniques?

Typing CO_2 easily

Limit max CPU usage SQL SERVER with WSRM

Do I have to take mana from my deck or hand when tapping a dual land?

Isometric embedding of a genus g surface

Language involving irrational number is not a CFL

What does "tick" mean in this sentence?

How do you justify more code being written by following clean code practices?

If Captain Marvel (MCU) were to have a child with a human male, would the child be human or Kree?

Ways of geometrical multiplication

What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?

How can I, as DM, avoid the Conga Line of Death occurring when implementing some form of flanking rule?

How do I fix the group tension caused by my character stealing and possibly killing without provocation?

How do I tell my boss that I'm quitting in 15 days (a colleague left this week)

Visualizing the difference curve in a 2D plot?

How would a solely written language work mechanically

Integral Notations in Quantum Mechanics

Personal or impersonal in a technical resume

Pre-Employment Background Check With Consent For Future Checks

How to reduce predictors the right way for a logistic regression model

Using streams for a null-safe conversion from an array to list

Why does a 97 / 92 key piano exist by Bösendorfer?

Review your own paper in Mathematics

Using postgres to select a filtered array

0

I'm looking to select data from a table that contains an ID, and an array of values. But in the query results, i want to filter the array and remove values that overlap with a white list.

For illustrative purposes, the following query shows how the data would be formatted with a whitelist of values in a single column, and then a table i want to select from that contains a unique ID, and the array of keywords.

with whitelist as (

    select distinct unnest(array['a','b','c','f','h']) as keywords

), raw_with_keyword_array as (

    select * from  (

        values 

            ('1234', array['a','c','e','h','q']),

            ('1235', array['a','d','e','f']) 

    ) as t (id, keyword_array)

)

select...

The expected results i'm looking for is two rows from the raw_with_keyword_array table, but filtered arrays not including the values from the whitelist.

E.g.

1234 {e, q}

1235 {d, e}

postgresql query array

share

asked 37 secs ago

Rob AlfordRob Alford

1

New contributor

Rob Alford is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I'm looking to select data from a table that contains an ID, and an array of values. But in the query results, i want to filter the array and remove values that overlap with a white list.

For illustrative purposes, the following query shows how the data would be formatted with a whitelist of values in a single column, and then a table i want to select from that contains a unique ID, and the array of keywords.

with whitelist as (

    select distinct unnest(array['a','b','c','f','h']) as keywords

), raw_with_keyword_array as (

    select * from  (

        values 

            ('1234', array['a','c','e','h','q']),

            ('1235', array['a','d','e','f']) 

    ) as t (id, keyword_array)

)

select...

The expected results i'm looking for is two rows from the raw_with_keyword_array table, but filtered arrays not including the values from the whitelist.

E.g.

1234 {e, q}

1235 {d, e}

postgresql query array

share

asked 37 secs ago

Rob AlfordRob Alford

1

New contributor

Rob Alford is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I'm looking to select data from a table that contains an ID, and an array of values. But in the query results, i want to filter the array and remove values that overlap with a white list.

For illustrative purposes, the following query shows how the data would be formatted with a whitelist of values in a single column, and then a table i want to select from that contains a unique ID, and the array of keywords.

with whitelist as (

    select distinct unnest(array['a','b','c','f','h']) as keywords

), raw_with_keyword_array as (

    select * from  (

        values 

            ('1234', array['a','c','e','h','q']),

            ('1235', array['a','d','e','f']) 

    ) as t (id, keyword_array)

)

select...

The expected results i'm looking for is two rows from the raw_with_keyword_array table, but filtered arrays not including the values from the whitelist.

E.g.

1234 {e, q}

1235 {d, e}

postgresql query array

share

asked 37 secs ago

Rob AlfordRob Alford

1

New contributor

Rob Alford is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

with whitelist as (

    select distinct unnest(array['a','b','c','f','h']) as keywords

), raw_with_keyword_array as (

    select * from  (

        values 

            ('1234', array['a','c','e','h','q']),

            ('1235', array['a','d','e','f']) 

    ) as t (id, keyword_array)

)

select...

share

asked 37 secs ago

Rob AlfordRob Alford

1

New contributor

Rob Alford is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 37 secs ago

Rob AlfordRob Alford

1

New contributor

Rob Alford is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 37 secs ago

Rob AlfordRob Alford

1

New contributor

Rob Alford is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 37 secs ago

Rob AlfordRob Alford

1