Re: Execute a function? - Mailing list pgadmin-support

From Dave Page
Subject Re: Execute a function?
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E472BB40@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Execute a function?  ("Steve - DND" <postgres@digitalnothing.com>)
List pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Steve - DND
> Sent: 15 March 2005 05:55
> To: Mark A. Taff; pgadmin-support@postgresql.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


pgadmin-support by date:

Previous
From: Sim Zacks
Date:
Subject: Re: Execute a function?
Next
From: "Igor Katrayev"
Date:
Subject: pgAdmin III v 1.2.0 (Nov 29 2004) bug. New table dialog does not save comments for columns