Re: Error message: standard SQL or PostgreQSL?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Huub <v(dot)niekerk(at)freeler(dot)nl>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Error message: standard SQL or PostgreQSL?
Date: 2002-11-15 15:42:24
Message-ID: 20021115073908.R9290-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Fri, 15 Nov 2002, Huub wrote:

> Hi,
>
> When I copied a function call into an SQL-statement and executed it, I
> got the message 'Aggregate function calls may not be nested'. Does that
> mean this is the case in standard SQL or is this specifically PostgreSQL?

Umm, both sort of. It's an entry level SQL92 restriction IIRC, so
both allowing it and not allowing it are standard SQL to some degree.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2002-11-15 16:59:21 Re: Proposal of hierarchical queries, a la Oracle
Previous Message Tom Lane 2002-11-15 15:20:53 Re: Error message: standard SQL or PostgreQSL?