Re: top predicate - Mailing list pgsql-general

From Tom Lane
Subject Re: top predicate
Date
Msg-id 18774.1147381136@sss.pgh.pa.us
Whole thread Raw
In response to top predicate  ("Karen Hill" <karen_hill22@yahoo.com>)
Responses Re: top predicate
List pgsql-general
"Karen Hill" <karen_hill22@yahoo.com> writes:
> It seems PostgreSQL doesn't have a TOP Predicate.  Why is that?

It's not in the SQL standard.  If we were to implement something like
what I think you're asking for (your example is way underspecified),
it'd probably look like SQL2003's window functions.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SIGSEGV happens over once a day
Next
From: Martijn van Oosterhout
Date:
Subject: Re: SIGSEGV happens over once a day