From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | lennin(dot)caro(at)yahoo(dot)com |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org>, "Ruben Gouveia" <rubes7202(at)gmail(dot)com> |
Subject: | Re: Correct Insert SQL syntax? |
Date: | 2008-09-05 16:16:03 |
Message-ID: | dcc563d10809050916j5b543fbfx69431afda5f688d3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Fri, Sep 5, 2008 at 10:11 AM, Lennin Caro <lennin(dot)caro(at)yahoo(dot)com> wrote:
> --- On Thu, 9/4/08, Ruben Gouveia <rubes7202(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Duffy | 2008-09-05 19:50:54 | variables with SELECT statement |
Previous Message | Lennin Caro | 2008-09-05 16:11:58 | Re: Correct Insert SQL syntax? |