Insert INTO where clause on postgresql

Question

Possible Duplicate:
Insert, on duplicate update (postgresql)

Is this possible on PostgreSQL:

insert record, if the record doesn't exists
else update existing record

Supposedly that the record will be inserted in this table structure:

[userid - unique] [count]

If there was an existing record, I will just update the count or insert if it doesn't exists

Try this: http://stackoverflow.com/questions/1109061/insert-on-duplicate-update-postgresql — acattle, May 27 '12 at 13:24

score 2 · Answer 1 · answered May 27 '12 at 16:30

2

You have to write a Function to do that in PostgreSQL, since there isn't something similar to mysql's INSERT ... ON DUPLICATE KEY UPDATE . Take a look at this function at PostgreSQL official documentation.

answered May 27 '12 at 16:30

aleroot

71,077
30
176
213

Insert INTO where clause on postgresql

1 Answers1