Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Technical Lead:- Yogesh Sir
using (NpgsqlConnection con = new
NpgsqlConnection(connection string));
Example:
Using ADO.NET
create or replace function insertdata(
ref1 refcursor,
con integer,
n_id integer = 0,
n_name varchar = null,
n_city varchar = null
)
returns refcursor AS
$func$
begin
if con = 1 then
insert into mytbl(Nid,Nname,Ncity)
values(n_id,n_name,n_city);
open ref1 for
select * from table_name order by Nid desc limit 1;
return ref1;
end if;
Insert function
Output:
Example: