Forum: >>> Magnum BBS <<<

[Info-ingres] create function, if test and javascript

From Martin Bowes@21:1/5 to All on Tue Jun 15 12:43:42 2021

Hi All,

create or replace function max(
a float8 not null not default,
b float8 not null not default
)
return (float8 not null) as
begin
if (:a >= :b) then
return :a;
else
return :b;
endif;
end;
\p\g

Now that doesn't work as SQL based UDFs can't use the IF-THEN-ENDIF syntax. That seems way too restrictive to me.

But I thought, we could just as easily do the test in JavaScript which is supposed to be supported. So...
create or replace function max(
a float8 not null not default,
b float8 not null not default
)
return (float8 not null) as LANGUAGE JAVASCRIPT SOURCE = 'if (a >= b) {return a} else {return b}';
Executing . . .

E_PS0316 Unrecognised UDF language: 'javascript'

Any suggestions?

Marty

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style>
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
Hi All,<o:p></o:p>
<o:p> </o:p>
create or replace function max(<o:p></o:p>
    a float8 not null not default,<o:p></o:p>
    b float8 not null not default<o:p></o:p>
)<o:p></o:p>
return (float8 not null) as<o:p></o:p>
begin<o:p></o:p>
    if (:a >= :b) then<o:p></o:p>
        return :a;<o:p></o:p>
    else<o:p></o:p>
        return :b;<o:p></o:p>
    endif;<o:p></o:p>
end;<o:p></o:p>
\p\g<o:p></o:p>
<o:p> </o:p>
Now that doesn’t work as SQL based UDFs can’t use the IF-THEN-ENDIF syntax. That seems way too restrictive to me.<o:p></o:p>
<o:p> </o:p>
But I thought, we could just as easily do the test in JavaScript which is supposed to be supported. So…<o:p></o:p>
create or replace function max(<o:p></o:p>
    a float8 not null not default,<o:p></o:p>
    b float8 not null not default<o:p></o:p>
)<o:p></o:p>
return (float8 not null) as LANGUAGE JAVASCRIPT SOURCE = 'if (a >= b) {return a} else {return b}';<o:p></o:p>
Executing . . .<o:p></o:p>
<o:p> </o:p>
E_PS0316 Unrecognised UDF language: 'javascript'<o:p></o:p>
<o:p> </o:p>
Any suggestions?<o:p></o:p>
<o:p> </o:p>
Marty<o:p></o:p>
</div>
</body>
</html>

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Who's Online
Recent Visitors
- Briels
  Tue Apr 23 20:54:03 2024
  from Uk via SSH
- Cronus
  Tue Apr 23 19:46:51 2024
  from Provo, Ut via SSH
- Keyop
  Tue Apr 23 19:40:37 2024
  from Huddersfield, West Yorkshire via SSH
- Guest
  Wed Apr 24 01:40:10 2024
  from A via Telnet

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	296
Nodes:	16 (2 / 14)
Uptime:	21:14:16
Calls:	6,646
Calls today:	1
Files:	12,190
Messages:	5,327,493

[Info-ingres] create function, if test and javascript

Who's Online

Recent Visitors

System Info