From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Steve - DND" <postgres(at)digitalnothing(dot)com>, "Mark A(dot) Taff" <marktaff(at)comcast(dot)net>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Execute a function? |
Date: | 2005-03-15 08:17:54 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E472BB40@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Katrayev | 2005-03-17 19:21:57 | pgAdmin III v 1.2.0 (Nov 29 2004) bug. New table dialog does not save comments for columns |
Previous Message | Sim Zacks | 2005-03-15 06:16:20 | Re: Execute a function? |