From: | "Mark A(dot) Taff" <marktaff(at)comcast(dot)net> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Execute a function? |
Date: | 2005-03-15 05:42:15 |
Message-ID: | 200503142142.15988.marktaff@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Monday 14 March 2005 21:31, you wrote:
> I'm completely baffled here. I've created a function, but how can I execute
> it? I tried opening up the SQL editor window and typed:
>
> test_function(20, 32);
> received: ERROR: syntax error at or near "test_function" at character 1
>
> I then tried:
> EXECUTE my_function(20, 32);
> received: ERROR: prepared statement "test_function" does not exist
>
> What the heck do I have to do to execute my functions to see the results of
> them? The function exists, it shows up in the list of functions for the DB.
> This seems so stupidly simple, and it probably is, so what am I doing
> wrong?
>
> Thanks,
> Steve
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Been a _very_long while, but try:
SELECT my_function(param_1, param_2) As Answer;
--
Mark A. Taff
From | Date | Subject | |
---|---|---|---|
Next Message | Steve - DND | 2005-03-15 05:55:24 | Re: Execute a function? |
Previous Message | Steve - DND | 2005-03-15 05:31:28 | Execute a function? |