Re: Correct Insert SQL syntax? - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Correct Insert SQL syntax?
Date
Msg-id dcc563d10809050916j5b543fbfx69431afda5f688d3@mail.gmail.com
Whole thread Raw
In response to Re: Correct Insert SQL syntax?  (Lennin Caro <lennin.caro@yahoo.com>)
List pgsql-sql
On Fri, Sep 5, 2008 at 10:11 AM, Lennin Caro <lennin.caro@yahoo.com> wrote:
> --- On Thu, 9/4/08, Ruben Gouveia <rubes7202@gmail.com> wrote:
>>                     ) (select
>>                           p_date,
>>
>> fcn_stats1(p_date,'basic'),
>>
>> fcn_stats2(p_date,'basic',0)
>>                           from dual
>
> Dual is a table create for you or is the generic table of oracle?

Dual is a special table oracle creates that always has one row and one
row only so you have a target for your from clause always.  PostgreSQL
has the syntactic weirdness that everything is a function that makes
some sql syntax hard to implement or get changed, oracle's weirdness
(well, one of many really) is the requirement of a target table.  the
spec would seem to side with oracle on this, but it is a pain the
butt.


pgsql-sql by date:

Previous
From: Lennin Caro
Date:
Subject: Re: Correct Insert SQL syntax?
Next
From: "Kevin Duffy"
Date:
Subject: variables with SELECT statement