Hi Craig! --- On Fri, 2/13/09, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote: > 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 ...); Thank you. Previously I tried: "... WHERE (...) IS NULL;". Of course, it didn't work. > > postgre check "empty result set" > > It's not "postgre". It's PostgreSQL, or > "postgres". This matters when > you're searching. Oh, okay. Thanks for telling me. > -- > Craig Ringer Best regards, Eus (FSF member #4445) In this digital era, where computing technology is pervasive, your freedom depends on the software controlling those computing devices. Join free software movement today! It is free as in freedom, not as in free beer! Join: http://www.fsf.org/jf?referrer=4445 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
