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: LDEHKBBOEMIJKHKBOFNFOEBLMBAA.postgres@digitalnothing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

Thanks,
Steve

Responses

Browse pgadmin-support by date

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