Re: [GENERAL] Is it possible to define a constraint based on thevalues in other rows in the current table? - Mailing list pgsql-general

> On 20 Jul 2017, at 5:26 AM, Hannes Erven <hannes@erven.at> wrote:
>
> Hi Glen,
>
>
>> I'd like to enforce that in a transaction, after a couple inserts &  > updates, a particular column has continuous
valueslike 1, 2, 3, and  
> > never any gaps. Is it possible to do?> > I gave a concrete example here: >
https://stackoverflow.com/questions/45187113didn't get any answers yet. 
> I've posted a comment to SO; basically what I'm saying is yes, use a transaction constraint trigger to enforce your
requirement.
>
> This previous question has an example of such a trigger:
>
> https://stackoverflow.com/a/37277421/1980653
>
>
> HTH & best regards
>
>     -hannes

Using a trigger sounds like the right approach. I’ll try it out. Thanks guys.

Hannes, thanks for posting an answer to SO, I’ve accepted it. :)