if row has property X, find all rows that has property X

Поиск
Список
Период
Сортировка
От Дмитрий Голубь
Тема if row has property X, find all rows that has property X
Дата
Msg-id 302594EA-F228-4D95-80A7-6F38690C7C58@me.com
обсуждение исходный текст
Ответы Re: if row has property X, find all rows that has property X
Список pgsql-general
For example I have table addresses and usually I want 2 things:
1. Find id of bad addresses.
2. Check if this address is good or bad.

For this I write two plpgsql functions
1. find_all_bad_addresses
2. is_bad_address(id)

These functions will duplicate logic of each other. How to not repeat myself?
Thanks


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