Re: How to check: is some key referenced from sometable - Mailing list pgsql-sql

On Mon, Aug 04, 2003 at 11:17:56 +0300, evl@my-mail.com.ua wrote:
> Please help.
> 
> Need a boolean function which returns true if given key in table is
> referensed from another table(s).

Use "exists" with a subselect. Something like:
select exists(select 1 from table where table.key = 'value');