If you have a function that returns a recordset instead of just a
value then you would have to do a select * from functionname
You can also try reading the documentation on functions. I believe
section 35 discusses the various pl languages.
Sim
_
> 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?
Steve
---(end o
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:
>
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
In the italian translation, I see this message:
"Connezione al database senza password"
The correct word is "Connessione". I suspect the same error appears in
multiple places.
Gino Lucrezi
Penta Consulting Services Srl
---(end of broadcast)---
TI
