Styjun

Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?

How to grep and cut numbers from a file and sum them

I could not break this equation. Please help me

Can smartphones with the same camera sensor have different image quality?

Why not take a picture of a closer black hole?

How does this infinite series simplify to an integral?

Does the AirPods case need to be around while listening via an iOS Device?

Mortgage adviser recommends a longer term than necessary combined with overpayments

Why can't devices on different VLANs, but on the same subnet, communicate?

What information about me do stores get via my credit card?

What is special about square numbers here?

Scientific Reports - Significant Figures

Did the new image of black hole confirm the general theory of relativity?

University's motivation for having tenure-track positions

How to test the equality of two Pearson correlation coefficients computed from the same sample?

Am I ethically obligated to go into work on an off day if the reason is sudden?

How is simplicity better than precision and clarity in prose?

Single author papers against my advisor's will?

Can a novice safely splice in wire to lengthen 5V charging cable?

Make it rain characters

Was credit for the black hole image misattributed?

Difference between "generating set" and free product?

Why did all the guest students take carriages to the Yule Ball?

How to copy the contents of all files with a certain name into a new file?

PostgreSQL How to query String array

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I am trying to write a query to check if an element is within an array of Strings.

Here is my simple select query along with the output

select languages from person limit 3;
CSS,HTML,Java,JavaScript,Python
JavaScript,Python,TensorFlow
C++,Python

How do I write a query to find all people who have "Java" as a listed language they know?

I tried following the syntax but it isn't working.

select languages from person where languages @> ARRAY['Java']::varchar[];

sql arrays postgresql

share|improve this question

edited Mar 22 at 6:42

a_horse_with_no_name

308k46471573

asked Mar 22 at 6:34

SandySandy

3301516

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Getting this error - cannot resolve 'Java' given input columns:
  
  – Sandy
  Mar 22 at 6:40
  

  
  
  
  

add a comment | 

0

I am trying to write a query to check if an element is within an array of Strings.

Here is my simple select query along with the output

select languages from person limit 3;
CSS,HTML,Java,JavaScript,Python
JavaScript,Python,TensorFlow
C++,Python

How do I write a query to find all people who have "Java" as a listed language they know?

I tried following the syntax but it isn't working.

select languages from person where languages @> ARRAY['Java']::varchar[];

sql arrays postgresql

share|improve this question

edited Mar 22 at 6:42

a_horse_with_no_name

308k46471573

asked Mar 22 at 6:34

SandySandy

3301516

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Getting this error - cannot resolve 'Java' given input columns:
  
  – Sandy
  Mar 22 at 6:40
  

  
  
  
  

add a comment | 

I am trying to write a query to check if an element is within an array of Strings.

Here is my simple select query along with the output

select languages from person limit 3;
CSS,HTML,Java,JavaScript,Python
JavaScript,Python,TensorFlow
C++,Python

How do I write a query to find all people who have "Java" as a listed language they know?

I tried following the syntax but it isn't working.

select languages from person where languages @> ARRAY['Java']::varchar[];

sql arrays postgresql

share|improve this question

edited Mar 22 at 6:42

a_horse_with_no_name

308k46471573

asked Mar 22 at 6:34

SandySandy

3301516

select languages from person limit 3;
CSS,HTML,Java,JavaScript,Python
JavaScript,Python,TensorFlow
C++,Python

select languages from person where languages @> ARRAY['Java']::varchar[];

share|improve this question

edited Mar 22 at 6:42

a_horse_with_no_name

308k46471573

asked Mar 22 at 6:34

SandySandy

3301516

share|improve this question

edited Mar 22 at 6:42

a_horse_with_no_name

308k46471573

asked Mar 22 at 6:34

SandySandy

3301516

edited Mar 22 at 6:42

a_horse_with_no_name

308k46471573

edited Mar 22 at 6:42

a_horse_with_no_name

308k46471573

asked Mar 22 at 6:34

SandySandy

3301516

asked Mar 22 at 6:34

SandySandy

3301516

2 Answers
2

active

oldest

votes

1

You need to use a string constant on the left side, and the ANY operator on the array column:

select languages 
from person 
where 'Java' = any(languages);

This assumes languages is defined as text[] or varchar[] as your sample output indicates

share|improve this answer

answered Mar 22 at 6:43

a_horse_with_no_namea_horse_with_no_name

308k46471573

add a comment | 

1

try this

select languages from person where 'Java' = ANY (string_to_array(languages , ','))

share|improve this answer

answered Mar 22 at 6:43

Jophy jobJophy job

1,2021320

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55294104%2fpostgresql-how-to-query-string-array%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

You need to use a string constant on the left side, and the ANY operator on the array column:

select languages 
from person 
where 'Java' = any(languages);

This assumes languages is defined as text[] or varchar[] as your sample output indicates

share|improve this answer

answered Mar 22 at 6:43

a_horse_with_no_namea_horse_with_no_name

308k46471573

add a comment | 

1

You need to use a string constant on the left side, and the ANY operator on the array column:

select languages 
from person 
where 'Java' = any(languages);

This assumes languages is defined as text[] or varchar[] as your sample output indicates

share|improve this answer

answered Mar 22 at 6:43

a_horse_with_no_namea_horse_with_no_name

308k46471573

add a comment | 

You need to use a string constant on the left side, and the ANY operator on the array column:

select languages 
from person 
where 'Java' = any(languages);

This assumes languages is defined as text[] or varchar[] as your sample output indicates

share|improve this answer

answered Mar 22 at 6:43

a_horse_with_no_namea_horse_with_no_name

308k46471573

select languages 
from person 
where 'Java' = any(languages);

share|improve this answer

answered Mar 22 at 6:43

a_horse_with_no_namea_horse_with_no_name

308k46471573

answered Mar 22 at 6:43

a_horse_with_no_namea_horse_with_no_name

308k46471573

answered Mar 22 at 6:43

a_horse_with_no_namea_horse_with_no_name

308k46471573

1

try this

select languages from person where 'Java' = ANY (string_to_array(languages , ','))

share|improve this answer

answered Mar 22 at 6:43

Jophy jobJophy job

1,2021320

add a comment | 

1

try this

select languages from person where 'Java' = ANY (string_to_array(languages , ','))

share|improve this answer

answered Mar 22 at 6:43

Jophy jobJophy job

1,2021320

add a comment | 

try this

select languages from person where 'Java' = ANY (string_to_array(languages , ','))

share|improve this answer

answered Mar 22 at 6:43

Jophy jobJophy job

1,2021320

select languages from person where 'Java' = ANY (string_to_array(languages , ','))

share|improve this answer

answered Mar 22 at 6:43

Jophy jobJophy job

1,2021320

answered Mar 22 at 6:43

Jophy jobJophy job

1,2021320

answered Mar 22 at 6:43

Jophy jobJophy job

1,2021320