Re: OT - select + must have from - sql standard syntax?

From: "Dave Dutcher" <dave(at)tridecap(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: OT - select + must have from - sql standard syntax?
Date: 2006-06-14 13:58:48
Message-ID: 030a01c68fba$a90f5080$8300a8c0@tridecap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of
> Greg Stark
> Sent: Tuesday, June 13, 2006 11:16 PM
> Subject: Re: [PERFORM] OT - select + must have from - sql
> standard syntax?
[SNIP]
>
> Well you could always create a "dual", it was always just a
> regular table. We
> used to joke about what would happen to Oracle if you
> inserted an extra row in
> it...

I've never used Oracle, so I don't understand why its called dual when
it only has one row? Shouldn't it be called single? :\

Dave

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-06-14 14:20:41 Re: OT - select + must have from - sql standard syntax?
Previous Message Jim C. Nasby 2006-06-14 13:57:40 Re: Confirmation of bad query plan generated by 7.4