On 2010-12-07, Kobi Biton <kobi(at)comns(dot)co(dot)il> wrote:
> hi i am a newbie to sql statments , I am running postgres 8.1 with
> application called opennms version 1.8.5 due to an application bug
> queries that I execute aginst the DB which returns raw-count=0 are being
> ignored and will not process a certain trigger I need to process.
I think you want this:
ORIGINAL QUERY
union
select DUMMY ROW DATA
where
not exists ( ORIGINAL QUERY )
you need to return something to get a rowcount of 1 this is what the
dummy row data provides. the "where not exists" part blocks the dummy
row data when the main query returns something.
--
⚂⚃ 100% natural