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.