How can I restrict count of rows in postgresql

Question

In PostgreSQL, how can I restrict count of rows, I mean I have table which is users and I want to set a limit for example 10 so 10 must be the top limit of count. How can I do that ?

Thanks in Advance...

what do you mean by limit count? do you mean limit the number of rows returned? or you are counting rows and you want the max count to be 10? — John Ruddell
– John Ruddell, Commented Feb 4, 2015 at 16:24
I want to have maximum 10 users, I think it's more clear now. — Vivian Maya
– Vivian Maya, Commented Feb 4, 2015 at 16:26
have you made any attempts? any sql code you have? maybe something like this? SELECT * FROM users LIMIT 10; — John Ruddell
– John Ruddell, Commented Feb 4, 2015 at 16:28

Mike Sherrill 'Cat Recall' · Accepted Answer · 2015-02-04 16:31:07Z

3

You can use a CHECK constraint on an id number.

create table users (
  user_id integer primary key
    check (user_id between 1 and 10),
  user_name varchar(35) not null
);

I think you're better off with an integer than with serial for this, since you're using only 10 rows.

answered Feb 4, 2015 at 16:31

Mike Sherrill 'Cat Recall'

96.6k20 gold badges134 silver badges195 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I restrict count of rows in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related