Post reply

Conditional DELETE and INSERT in PostgreSQL

  • 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

  • June 18, 2021 at 2:18 pm

    #3898004

    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.

     

  • June 19, 2021 at 5:04 am

    #3898255

    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

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

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