Re: Am I crazy or is this SQL not possible - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: Am I crazy or is this SQL not possible
Date
Msg-id 20060601195405.GH19388@surnet.cl
Whole thread Raw
In response to Re: Am I crazy or is this SQL not possible  (Yasir Malik <ymalik@cs.stevens.edu>)
List 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.


pgsql-sql by date:

Previous
From: Yasir Malik
Date:
Subject: Re: Am I crazy or is this SQL not possible
Next
From: Scott Marlowe
Date:
Subject: Re: Am I crazy or is this SQL not possible