Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
CALCULATOR USING PL/PGSQL FUNCTIONS
CREATE OR REPLACE FUNCTION cal( a NUMERIC, b NUMERIC, c NUMERIC, OUT summ NUMERIC, OUT diff NUMERIC, OUT mul NUMERIC, OUT div NUMERIC, OUT mod NUMERIC, OUT pow NUMERIC, OUT hi NUMERIC, OUT lo NUMERIC ) RETURNS record AS $$ BEGIN summ :=a+b+c; diff:=c-b-a; mul :=c*b*a; div :=c/b; mod :=c%a; pow :=POWER(a,2); hi := GREATEST(a,b,c); lo := LEAST(a,b,c); END; $$ LANGUAGE plpgsql; select * from cal(10,20,30)
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Pivot the Hard Way.
Projeto
Demo
complicated-conditional-sql-query-to-match-attributes-for-marketing-campaigns/43219741#43219741
Inner Join
FINALE fdjfnkds
Sample tables
Assignment 1(SET A)
as
renaming JSON field
Please log in to post a comment.