Ian Harding wrote:
A tcl function is just like any other, you can call it from within a plpgsql trigger function in the same way you would call a built-in, or any other function. Having said that, I am not sure what the exact plpgsql options are besides "SELECT myfunction(' 'foo' ', ' 'bar' ') ...." and don't know syntax for storing the returned value in a variable. I'm a one-trick pony.
What about
plpgsql_variable := tcl_or_any_other_function();
You can also pass some arguments, but that doesn't count as another trick, it's just a modification to an already seen one.
Jan
Josué Maldonado wrote:
Hi list,
That's the question, anyone knows a way to do that?
Thanks in advance,
Josue Maldonado.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
