On Mon, Aug 23, 2010 at 06:07:08PM -0500, san man wrote:
> Thanks for the replies.
> David, I would have normalized it to 2 or more tables, but the number of
> bar-delimited are not fixed and as new data are added the maximum number of
> these values may change. Also, the problem with like I think
On Mon, Aug 23, 2010 at 8:21 PM, Craig Ringer
wrote:
> On 08/24/2010 07:07 AM, san man wrote:
>>
>> Thanks for the replies.
>> David, I would have normalized it to 2 or more tables, but the number of
>> bar-delimited are not fixed and as new data are added the maximum number
>> of these values may
On 08/24/2010 07:07 AM, san man wrote:
Thanks for the replies.
David, I would have normalized it to 2 or more tables, but the number of
bar-delimited are not fixed and as new data are added the maximum number
of these values may change. Also, the problem with like I think is that
matching is not
Thanks for the replies.
David, I would have normalized it to 2 or more tables, but the number of
bar-delimited are not fixed and as new data are added the maximum number of
these values may change. Also, the problem with like I think is that
matching is not strict and thus might give spurious hits.
On Tue, Aug 24, 2010 at 12:44 AM, san man wrote:
> 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
> m
On Mon, Aug 23, 2010 at 05:44:09PM -0500, san man wrote:
> 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 condit
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 i
