Re: Return value in function/trigger

From: Neil Conway <neilc(at)samurai(dot)com>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Return value in function/trigger
Date: 2002-11-20 05:09:17
Message-ID: 87zns4j08y.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> Which is better/faster and why? I would think there is some overhead
> in returning NEW whereas returning NULL would have less?

I'd suspect returning NULL (or just 'RETURN;') would be a few cycles
faster. However, unless the tuple you're returning is *really* large, I
doubt it would make a significant performance difference.

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-11-20 06:49:05 Re: [GENERAL] Request for reference sites
Previous Message Jeffrey Melloy 2002-11-20 05:03:32 Re: Getting a list of tables in a database with Perl