Re: Execute a function?

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Steve - DND
> Sent: 15 March 2005 05:55
> To: Mark A. Taff; pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Execute a function?
> 
> > Been a _very_long while, but try:
> >
> > SELECT my_function(param_1, param_2) As Answer;
> 
> Yep, that did it. I'm such a newb with PG, still trying 
> everything the MSSQL
> way first. Is that the proper way to do it even if you have a 
> function that
> returns void?

Yeah, though you'd omit the 'As Answer' (which will fold to lower case
without quotes btw). That bit just gives the resulting column an alias.

Regards, Dave