Re: Am I crazy or is this SQL not possible

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Yasir Malik <ymalik(at)cs(dot)stevens(dot)edu>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Am I crazy or is this SQL not possible
Date: 2006-06-01 19:54:05
Message-ID: 20060601195405.GH19388@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2006-06-01 19:54:59 Re: Am I crazy or is this SQL not possible
Previous Message Yasir Malik 2006-06-01 19:47:57 Re: Am I crazy or is this SQL not possible