Re: Return value in function/trigger - Mailing list pgsql-general

From Neil Conway
Subject Re: Return value in function/trigger
Date
Msg-id 87zns4j08y.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: Return value in function/trigger  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Jean-Christian Imbeault <jc@mega-bucks.co.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@samurai.com> || PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Jeffrey Melloy
Date:
Subject: Re: Getting a list of tables in a database with Perl
Next
From: Justin Clift
Date:
Subject: Re: Request for reference sites