how to write function

[Anon]

I am getting following error when i wrote simple function.

ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plsql'.
Recognized languages are sql, C, internal, and created procedural languages.

plz give me simple example how to write function.

regards
Krishna Reddy

[sayoko]

function calculator ($a, $b)
{
$c = $a*$b;

return $c;
}

echo calculator("2", "5");

returns 10.

Your plsql is maybe a reserved word used by PHP.

Like function echo () wouldn´t work since echo is a PHP command.

[[deleted]]

You must install the plsql language in your datbaase before you can use it.

Read the 'plsql' section of the postgresql manual at the postgres website.