Thank you, Gary. That was actually the page I was looking at when I wrote the code. I've tried every combination that I can think of (including using NEW.location.region) but it always returns the same error about whatever not being a known variable.

Well at a minimum I think you have to return New for it do what you want. 42.3 example. Your Raises are commented out so do nothing. Yeah I would think you need New. loc.... I assume you have that column in the table.

Yep, same error when using NEW.location.region. The column is in the table.

may have something to do with . in the column not sure how that might or not impact things. It seems to work for your if though but that could just be it failing the test.

Yeah, I'm at a loss. I updated the code to use: UPDATE location SET NEW.location.region = "Truckee"; This gets accepted, but returns the error: Error: missing FROM-clause entry for table "location"

What exactly are the relevant column names and types? Not quite sure what you are up to with the name.name although I've not messed with all the data types.

Thank you! That got me closer! Now I'm not getting any errors, but the "region" field isn't getting updated. Here's the current code:

CREATE OR REPLACE FUNCTION setRegion() RETURNS trigger AS $$

BEGIN
  IF NEW.address LIKE '%Truckee%' 
    THEN NEW.region = 'Truckee';
      --UPDATE location SET NEW.location.region = "Truckee";
    ELSE NEW.region = 'Tahoe';
    -- UPDATE location SET NEW.location.region = "Tahoe";
  END IF;
  RETURN null;  
END;

$$ LANGUAGE plpgsql;

return NEW not null

You're a genius! That was it! I also learned that I have to refresh the table editor to see the new value. 🙂