using result as part of regular expression

From: larry a price <laprice(at)efn(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: using result as part of regular expression
Date: 2001-04-12 19:53:28
Message-ID: Pine.GSU.4.21.0104121236550.23319-100000@garcia.efn.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

what i want to do is relatively simple, i have two tables which have some
information in common except that the 2nd table's name attribute was
truncated and is in lower case.

what i'd like to be able to do is something like

SELECT table1.name,table2.web,table2.email
WHERE table1.name LIKE upper(table2.name).'%';
^^^^^^ trying for
'content%'
in other words if table2.name is 'Some Charitable Org' i'd want to pass it
to the comparison function as 'SOME CHARITABLE ORG%' so it would match
'SOME CHARITABLE ORGANISATION' in table1.name.

I've been looking through the docs and the book (momjian) but can't seem
to find the bit of syntax i need.

Thanks in advance,
larry

Larry Price | "We have seen the truth.
laprice(at)efn(dot)org | And the truth makes no sense." -chesterton
_______________________________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-12 20:40:28 Re: using result as part of regular expression
Previous Message Howard Williams 2001-04-12 18:19:11