Skip site navigation (1) Skip section navigation (2)

Execute a function?

From: "Steve - DND" <postgres(at)digitalnothing(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Execute a function?
Date: 2005-03-15 05:31:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
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?



pgadmin-support by date

Next:From: Mark A. TaffDate: 2005-03-15 05:42:15
Subject: Re: Execute a function?
Previous:From: Gino LucreziDate: 2005-03-14 10:37:15
Subject: Wrong translation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group