Postgres Pro
Downloads
Home   >   mailing lists

Re: Check if column is substring of another column - Mailing list pgsql-general

From Richard Huxton
Subject Re: Check if column is substring of another column
Date
Msg-id 49782520.2000305@archonet.com
Whole thread Raw
In response to Check if column is substring of another column  (Keaton Adams <kadams@mxlogic.com>)
List pgsql-general
Tree view 
Keaton Adams wrote:
> PostgreSQL 8.1 question:
>
> I have two columns.
> policyNumber contains a 12-13 varchar string
> AllPolicyNumbersIncluded contains one or more 12-13 varchar strings (policy nums) separated by commas

Rodrigo has given a direct answer, but you might want to consider either
an array of text for AllPolicyNumbersIncluded or better still a join to
another table. That will make your queries more natural.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Abdul Rahman
Date:
Subject: Re: autovacuum daemon
Next
From: Igor Katson
Date:
Subject: Re: [Plproxy-users] A complex plproxy query