testing.sql

with orig as (
	select 'original value'::text as foo limit 1
),
orig_if_not as (
	select 'the value if first query returns no rows'::text as foo 
)
select coalesce(a.foo, b.foo) as the_foo 
from orig a
right join orig_if_not b on (a.foo is not null)