Replace into equivalent for postgresql and then autoincrementing an int

Question

Okay no seriously, if a postgresql guru can help out I'm just getting started.

Basically what I want is a simple table like such:

CREATE TABLE schema.searches
(
  search_id serial NOT NULL,
  search_query character varying(255),
  search_count integer DEFAULT 1,
  CONSTRAINT pkey_search_id PRIMARY KEY (search_id)
)
WITH (
  OIDS=FALSE
);

I need something like REPLACE INTO for mysql. I don't know if I have to write my own procedure or something?

Basically:

• check if the query already exists
• if so, just add 1 to the count
• it not, add it to the db

I can do this in my php code but I'd rather all that be done in postgres C engine

Thanks for helping

Answer 1

Here is an example of how to make a procedure to do upsert:

http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE