Re: [HACKERS] Enhancing PGSQL to be compatible with InformixSQL

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Don Baccus <dhogaza(at)pacifier(dot)com>, Rod Chamberlin <rod(at)querix(dot)com>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Enhancing PGSQL to be compatible with InformixSQL
Date: 2000-01-06 19:17:17
Message-ID: 200001061917.OAA16902@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > I've been wanting outer joins, but in my porting efforts have managed
> > to work around them without too much difficulty, even though 6.5's
> > limitations on subselects (not in target lists) requires that I
> > create PL/pgSQL functions in some cases.
> > I certainly can't speak for the majority of users, but as one data
> > point I'd personally rather see outer joins done right (SQL 92
> > syntax) and wait a bit.
>
> A bit of a misunderstanding here: we are using SQL92 syntax but will
> try to implement the outer join operation using *internal* data
> structures similar to what we have now.
>
> Any alternate syntaxes are just a diversion which slow us down on the
> road to world domination ;)

OK, I stand corrected. Let world domination continue.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Patrick Welche,SCC,ext.35710, 2000-01-06 20:27:00 vacuum problem
Previous Message Bruce Momjian 2000-01-06 19:16:30 Re: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL