Postgres Pro
Downloads
Home   >   mailing lists

if row has property X, find all rows that has property X - Mailing list pgsql-general

From Дмитрий Голубь
Subject if row has property X, find all rows that has property X
Date
Msg-id 302594EA-F228-4D95-80A7-6F38690C7C58@me.com
Whole thread Raw
Responses Re: if row has property X, find all rows that has property X
List pgsql-general
Tree view 
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 by date:

Previous
From: Rene Romero Benavides
Date:
Subject: Re: Taking rsynced base-backup without wal-archiving enabled
Next
From: David G Johnston
Date:
Subject: Re: if row has property X, find all rows that has property X