Conditional DELETE and INSERT in PostgreSQL

Question

Conditional DELETE and INSERT in PostgreSQL

sabyda

Old Hand

Points: 334
More actions
May 12, 2021 at 4:44 pm

#3882419

Comments posted to this topic are about the item Conditional DELETE and INSERT in PostgreSQL
Sabyasachi Mukherjee

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

timwell SSCertifiable Points: 5315 More actions · Answer 1

Thank you. I am starting to work on converting MS SQL to PostgreSQL so this is helpful.

There is some minor confusion in your first example. Based on the order of the INSERT statements I would have thought that the David record would have been assigned employee_id of 3. However this row gets deleted because he was apparently assigned employee_id 2? Is there something else going on that would have changed the order of assignment?

I get what you are showing, but it seems that might be confusing for some who are not familiar with the SERIAL pseudo-type and sequences.

sabyda Old Hand Points: 334 More actions · Answer 2

You're right Tim. Now I remember, possibly I ran the query in the other order for David and Stephen. Later when I attached the queries for reference, I pasted in other order. Rightly pointed out. Thanks.

Sabyasachi Mukherjee

Conditional DELETE and INSERT in PostgreSQL

Cookies on SQLServerCentral