Subselect with limit - Mailing list pgsql-general

From A B
Subject Subselect with limit
Date
Msg-id dbbf25900807250252r22a49c87i4c2c2bde99bad1c5@mail.gmail.com
Whole thread Raw
List pgsql-general
I guess I can't do like this
SELECT   id,a,b  FROM  T  WHERE id NOT IN (SELECT id FROM T2 WHERE
c=5) LIMIT 20;

I only want 20 rows.
How do I do it?

I have table
T (
id ,a,b integer, primary key(id) );
T2 (id

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: I often have to do "update if exist, else insert", is my database design wrong?
Next
From: "A B"
Date:
Subject: limit with subselect