Tom Lane wrote: > "Karen Hill" <[EMAIL PROTECTED]> 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. >
Hi Tom, The TOP predicate seemed to be really common in some other RDBMS. I guess it isn't in the standard since oracle seems to be missing it in 9i. Maybe 10g has it. http://www.oracle.com/technology/tech/migration/ama/exchange/docs/ss2k/SELECTStatement.htm ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
