Re: Found small issue with OUT params - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Found small issue with OUT params
Date
Msg-id 20050930154951.GB29738@svana.org
Whole thread Raw
In response to Re: Found small issue with OUT params  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Responses Re: Found small issue with OUT params
Re: Found small issue with OUT params
List pgsql-hackers
On Fri, Sep 30, 2005 at 10:20:34AM -0500, Tony Caduto wrote:
> Tom,
> I hardly think the overhead would be significant on modern processors, I
> don't think the majority of users are running on Pentium 90s.( I am
> assuming you mean a performance overhead)

Um, please read the documention. Returning a tuple is *significantly*
more expensive than returning a single value. You have to get the tuple
descriptor, allocate memory for the tuple, fill in all the fields with
your data... For a single value you just return it.

See here for all the details, you really don't want to do it if you
don't need to.

http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html#AEN30497

Now, you could fudge the parser to automatically alter the name of the
value in the function but I'm have no idea how hard that would be...
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

pgsql-hackers by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Found small issue with OUT params
Next
From: Thomas Hallgren
Date:
Subject: Re: Socket problem using beta2 on Windows-XP