CREATE OR REPLACE FUNCTION add_one_word(newword character varying)
  RETURNS character varying AS
$BODY$
DECLARE
	find_words INTEGER;
	newid INTEGER;
BEGIN
	newid :=  0 ;
	SELECT INTO find_words id FROM words WHERE name=newword;

	IF find_words IS NULL THEN
		INSERT INTO words VALUES(newword);
		SELECT INTO newid currval('public.words_id_seq');
	ELSE
		newid := find_words;
	END IF;

	RETURN newid;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;

CREATE TABLE words
(
  name character varying( 255 ) NOT NULL,
  id serial NOT NULL
) 
WITH OIDS;

CREATE UNIQUE INDEX word_name
  ON words
  USING btree
  (name);

BEGIN
	INSERT INTO words VALUES (newword);
		EXCEPTION
			WHEN UNIQUE_VIOLATION THEN
				SELECT INTO find_words id FROM words WHERE name=newword;
				RETURN find_words;
SELECT INTO newid currval('public.words_id_seq');	
END;
RETURN newid;