Learn about Creating Functions in PostgreSQL.
Tag: postgresql function, [vid_tags]
Xem thêm: https://meohay360.com/category/internet
Nguồn: https://meohay360.com
Internet
Tutorial 42 – Creating Functions in PostgreSQL
21
Th3
Th3
Learn about Creating Functions in PostgreSQL.
Tag: postgresql function, [vid_tags]
Xem thêm: https://meohay360.com/category/internet
Nguồn: https://meohay360.com
How can I return more than one value?
Can I use a table as a parameter when creating a function?
where the hell is that company came from?
Best explanation out there !!! Simple and Concise
been trying to do this for 30 min.. just realized the thing with the '$$' ??? What's that about? Anyway, thanks!
well you copied that function from another website :
sir my sql editor panel is shifting how to resolve it
"So some of you are probably wondering what the hell on earth is this" 😂 that made me sub you great video! Keep it up!
How can I pass the dynamic table name to procedure and return it's record
Thumbs up for the "what the hell on earth is this" lol!
thanks a lot man god bless you
Thanks for the tuto !
how to create a procedure? How to convert oracle procedure to postgresql procedure ?
how do you execute the functions in postgresql to windows task scheduler?
._/_.
All code typed in the video:
create or replace function total()
returns integer as $total$
declare
total integer;
begin
select count(*) into total from company;
return total;
end;
$total$ language plpgsql;
select total()
create or replace function inc(value integer)
returns integer as $inc$
begin
returns value+1;
end;
$inc$ language plpgsql;
select inc(4);
select inc(6);
select inc(10);
create function sum(val1 integer, val2 integer)
returns integer as $sum$
begin
return val1+val2;
end;
$sum$ language plpgsql;
select sum(20, 30);
Thanx a lot man!, very usefuL!
Thanks for such an easy tutorial 🙂
"what the hell on earth is this" – i appreciate the down to earth commentary XD