Re: [GENERAL] Check if column is substring of another column

[Rodrigo E . De León Plicet]

On Wed, Jan 21, 2009 at 5:44 PM, Keaton Adams <kad...@mxlogic.com> wrote:
> Is there a way to do this in a single SQL statement in PostgreSQL 8.1?

SELECT
    d.policyNumber
  , d.CompanyName
  , d.Address
  , p.AllPolicyNumbersIncluded
FROM PolicyPrint p
  INNER JOIN PolicyDetails d
    ON (
      p.cicPolicyNumber = d.policyNumber
        OR
      p.AllPolicyNumbersIncluded LIKE '%' || d.policyNumber || '%'
    )

-- OR --

SELECT
    d.policyNumber
  , d.CompanyName
  , d.Address
  , p.AllPolicyNumbersIncluded
FROM PolicyPrint p
  INNER JOIN PolicyDetails d
    ON (
      p.cicPolicyNumber = d.policyNumber
        OR
      d.policyNumber = ANY(string_to_array(p.AllPolicyNumbersIncluded, ','))
    )

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general