Postgres Pro
Downloads
Home   >   mailing lists

select from pipe-delimited field - Mailing list pgsql-novice

From san man
Subject select from pipe-delimited field
Date
Msg-id AANLkTi=Y84tAz_MBVF0QwOGwE1QjMweKPoCh8naUPcak@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] select from pipe-delimited field  (David Fetter <david@fetter.org>)
Re: [GENERAL] select from pipe-delimited field  (Arjen Nienhuis <a.g.nienhuis@gmail.com>)
List pgsql-novice
Tree view
Hello all,

I am trying to do a SELECT operation with a WHERE condition. However, the column with which I am trying to do the comparison has several values which are pipe-delimited. I want to return a match(true) if the WHERE condition matches any of the bar-delimited values.

For example, SELECT id WHERE synonyms = 'word';

Here synonyms is a pipe-delimited field and I want to match "word" with any of the values of the synonyms fields.

Thanks in advance.

Neel

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: xml output
Next
From: David Fetter
Date:
Subject: Re: [GENERAL] select from pipe-delimited field