Sfrgttk

If I deleted a game I lost the disc for, can I reinstall it digitally?

Porting Linux to another platform requirements

awk + sum all numbers

Why zero tolerance on nudity in space?

Find some digits of factorial 17

Early credit roll before the end of the film

Strange Sign on Lab Door

Word or phrase for showing great skill at something WITHOUT formal training in it

Can making a creature unable to attack after it has been assigned as an attacker remove it from combat?

How long is the D&D Starter Set campaign?

Intern applicant asking for compensation equivalent to that of permanent employee

CREATE ASSEMBLY System.DirectoryServices.AccountManagement.dll without enabling TRUSTWORTHY

Why did the villain in the first Men in Black movie care about Earth's Cockroaches?

Why is mind meld hard for T'pol in Star Trek: Enterprise?

Eww, those bytes are gross

How should I handle players who ignore the session zero agreement?

How would an AI self awareness kill switch work?

How to avoid being sexist when trying to employ someone to function in a very sexist environment?

Caruana vs Carlsen game 10 (WCC) why not 18...Nxb6?

Publishing research using outdated methods

Can I become debt free or should I file bankruptcy ? How to manage my debt and finances?

Normalization for two bulk RNA-Seq samples to enable reliable fold-change estimation between genes

Are there any modern advantages of a fire piston?

How much mayhem could I cause as a sentient fish?

How to loop through each key/value pair in a jsonb OBJECT in postgresql stored procedure?

0

I am trying to create a function in postgres that can loop through each key/value pair in a given jsonb object.

create or replace function myFunction

(input jsonb)

returns jsonb as $$

BEGIN



    // foreach(key in input)

    //       do some math operation on its corresponding value



    returns input;



END; $$

The argument input is expected to be a jsonb OBJECT, such as {"a":1, "b":2, "c":3}.

So what I want to do, is to loop through each "key":value pair in the object. As you can tell from my comment, I used to write backend code with more general-purpose programming languages like c, java, etc. So I am not good at sql. I have tried to search online, but they talk about how to loop through jsonb array instead of object. So really stuck here.

sql-server postgresql

share

asked 49 secs ago

JaneLJaneL

1

New contributor

JaneL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am trying to create a function in postgres that can loop through each key/value pair in a given jsonb object.

create or replace function myFunction

(input jsonb)

returns jsonb as $$

BEGIN



    // foreach(key in input)

    //       do some math operation on its corresponding value



    returns input;



END; $$

The argument input is expected to be a jsonb OBJECT, such as {"a":1, "b":2, "c":3}.

So what I want to do, is to loop through each "key":value pair in the object. As you can tell from my comment, I used to write backend code with more general-purpose programming languages like c, java, etc. So I am not good at sql. I have tried to search online, but they talk about how to loop through jsonb array instead of object. So really stuck here.

sql-server postgresql

share

asked 49 secs ago

JaneLJaneL

1

New contributor

JaneL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am trying to create a function in postgres that can loop through each key/value pair in a given jsonb object.

create or replace function myFunction

(input jsonb)

returns jsonb as $$

BEGIN



    // foreach(key in input)

    //       do some math operation on its corresponding value



    returns input;



END; $$

The argument input is expected to be a jsonb OBJECT, such as {"a":1, "b":2, "c":3}.

So what I want to do, is to loop through each "key":value pair in the object. As you can tell from my comment, I used to write backend code with more general-purpose programming languages like c, java, etc. So I am not good at sql. I have tried to search online, but they talk about how to loop through jsonb array instead of object. So really stuck here.

sql-server postgresql

share

asked 49 secs ago

JaneLJaneL

1

New contributor

JaneL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

create or replace function myFunction

(input jsonb)

returns jsonb as $$

BEGIN



    // foreach(key in input)

    //       do some math operation on its corresponding value



    returns input;



END; $$

share

asked 49 secs ago

JaneLJaneL

1

New contributor

JaneL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 49 secs ago

JaneLJaneL

1

New contributor

JaneL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 49 secs ago

JaneLJaneL

1

New contributor

JaneL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 49 secs ago

JaneLJaneL

1