using result as part of regular expression

Поиск
Список
Период
Сортировка
От larry a price
Тема using result as part of regular expression
Дата
Msg-id Pine.GSU.4.21.0104121236550.23319-100000@garcia.efn.org
обсуждение исходный текст
Ответы Re: using result as part of regular expression  (Peter Eisentraut <peter_e@gmx.net>)
Список 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@efn.org  |   And the truth makes no sense." -chesterton
_______________________________________________________________



В списке pgsql-general по дате отправления:

Предыдущее
От: "Howard Williams"
Дата:
Сообщение:
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: using result as part of regular expression