Eus wrote: > Hi Ho! > > Is there a way to check whether or not a subquery returns an empty result set? "EXISTS" SELECT blah FROM blah WHERE EXISTS (SELECT 1 FROM tablename WHERE ...); > postgre check "empty result set" It's not "postgre". It's PostgreSQL, or "postgres". This matters when you're searching. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general