Skip to content
All gists
Back to GitHub
Sign in
Sign up
Sign in
Sign up
{{ message }}
Instantly share code, notes, and snippets.
leo-from-spb
/
fun42.sql
Created
Oct 23, 2017
Star
0
Fork
0
Star
Code
Revisions
1
Embed
What would you like to do?
Embed
Embed this gist in your website.
Share
Copy sharable link for this gist.
Clone via HTTPS
Clone with Git or checkout with SVN using the repository’s web address.
Learn more about clone URLs
Download ZIP
Postgres function result record
Raw
fun42.sql
create
function
fun42
(a
integer
, b
integer
, OUT c
bigint
, OUT d character varying)
returns record
language plpgsql
as
$$
begin
c
=
a
+
b;
d
=
c::
varchar
;
end;
$$;
do $$
declare
x record;
begin
x
=
fun42(a :
=
1
, b :
=
2
);
raise notice
'
c = %
'
,
x
.
c
;
raise notice
'
d = %
'
,
x
.
d
;
end$$;
Sign up for free
to join this conversation on GitHub
. Already have an account?
Sign in to comment
You can’t perform that action at this time.
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.