returns 0 row from plpgsql function

From: zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: returns 0 row from plpgsql function
Date: 2010-03-20 00:02:07
Message-ID: 9e434c4d1003191702s3a847651gc39fef16f9a3dd5b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear List

I use plpgsql function as a postfix mailserver look-up table. For
example to look up virtual email address.
If I don't host this email address, then the function returns null.
Because it's a 1 row of null value postfix logs a warning message.
Although it's harmless in that postfix takes no further action to
deliver mail, these warning messages fill up log table.

How can I return 0 row from plpgsql function?

Thanks

mr.wu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-03-20 04:02:10 Re: [GENERAL] MS Access 2007 update write conflict problem & resolution
Previous Message justin@magwerks.com 2010-03-19 20:47:52 Re: MS Access 2007 update write conflict problem & resolution