Yasir Malik wrote: > >It is a hack, but when someone wants you to do something in a way > >different from the norm, aren't they asking for a hack? > > > >SQL Server does something like > >select top (1) from .... > > > >I am thinking this is NOT a SQL-99 standard. > > > This was an interview with Amazon, and I don't think Amazon wanted a hack. > I hope Amazon doesn't use hacks. There has to be another way. It would > be cruel if they expected me know some database specific functionality.
Do they use PostgreSQL at Amazon? Maybe they wanted to know if you are aware of common non-standard tricks for whatever RDBMS they use. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq