I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Dave.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Dave Potts wrote
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
SELECT *
FROM somewhere
LIMIT 50; ---
David J.
btw: what is a psql function?
--
View this message in context:
On 11/25/2014 01:27 PM, Dave Potts wrote:
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Put a LIMIT on the query.
If that is not what you want then we will need to see the code and/or
get a
On 25/11/14 21:36, Adrian Klaver wrote:
On 11/25/2014 01:27 PM, Dave Potts wrote:
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Put a LIMIT on the query.
If that is not what you want then we
On 11/25/2014 01:56 PM, Dave Potts wrote:
On 25/11/14 21:36, Adrian Klaver wrote:
On 11/25/2014 01:27 PM, Dave Potts wrote:
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Put a LIMIT on the
Adrian Klaver-4 wrote
If I am only interested in get 2 entries per result set, I would expect
to see
Actually =2.
How do you determine which rows to keep, by id or something else?
1 xx,yy
2 xx,yy
1,dd,zz
2,dd,zz
1, ee,ff
Using LIMIT only gives
1 xx,yy
2 xx,yy
Sorry for not
On 25/11/14 22:24, David G Johnston wrote:
Thanks List, I think this is the right way to go.
Adrian Klaver-4 wrote
If I am only interested in get 2 entries per result set, I would expect
to see
Actually =2.
How do you determine which rows to keep, by id or something else?
1 xx,yy
2 xx,yy