Re: Stored functions

On Fri, Aug 19, 2005 at 12:07:57PM +0100, Nigel Horne wrote:
> The on-line manual,
> http://www.postgresql.org/docs/8.0/interactive/index.html,
> doesn't describe how to call stored functions, or if it does
> it's well hidden.
>
> Are there some examples anywhere? After
> googling I can find much duplication of non-data (people
> love to mirror sites don't they?) but no real examples.

I havn't checked the docs, but it is be exactly the same as normal
functions:

select my_new_function(1);
select my_new_function(col) from table;

etc...

--
Martijn van Oosterhout <kleptog(at)svana(dot)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.