Hi,
Personally where possible I would always internal features of any DB engine.
These are pre-compiled, tested for performance and are ingrained into the
system. So they can naturally be expected to be slightly faster than even
triggers. In the case of your question, why not use serial dat
On Fri, Oct 14, 2016 at 7:12 AM, Арсен Арутюнян wrote:
> Hi, everyone!
>
> I have a table:
>
> create table testpr(id serial,priority integer,unique(priority) DEFERRABLE,
> primary key(id));
>
This:
> and a trigger which, when added to this table, automatically sets priority
> as the maximum val