Re: limiting number of allowed rows in a table

Yes, I kinda had the same thing in mind about somehow using COUNT(*)
but without any success so far. Can you please give me a code fragment
on how would you implement this? Thanks.

On 12/28/05, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>
> I don't think there is such a constraint (but would love to hear otherwise).
> However, you could place a trigger on a table that does a count(*) on the
> table (which might be time-consuming on a large table, but....) and then
> does whatever you want (ignore the insert, put it in another table, or
> delete an old row before inserting the new one). Why do you want to limit
> the number of rows?
>
> Sean
>
>
>