Tom Lane wrote: > Andres Freund <and...@anarazel.de> writes: > > On 2015-04-01 12:46:05 -0400, Robert Haas wrote: > >> So, the idea is that INSTEAD OF would behave like BEFORE but the tuple > >> it returns wouldn't actually be inserted? That wasn't clear to me > >> from the OP, but I guess it would be a reasonable way to go. > > > I'm not sure what the OP intended, but to me that's pretty much the only > > reasonable definition of INSTEAD OF for tables that I can think of. > > If you have such a trigger, it's impossible to insert any rows, which > means the table doesn't need storage, which means it may as well be a > view, no?
The interesting difference, as per upthread, is that you can have child tables (partitions) and don't need a defining query but instead have a defined set of named and typed columns. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers