Hans-Jürgen Schönig wrote:
Neil Conway wrote:
Robert Treat wrote:
Actually i believe people want both syntax's as the former is used by
oracle and the latter by db2 (iirc)
I think the past consensus has been to adopt the SQL standard syntax. Is
there any reason to also
Bruce Momjian pgman@candle.pha.pa.us writes:
Hans-Jürgen Schönig wrote:
My compromise would be: Support both syntaxes if possible.
I can see your point, but imagine if we had Oracle compatibility for
lots of cases --- our system would have either non-standard or duplicate
ways of doing
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Hans-Jürgen Schönig wrote:
My compromise would be: Support both syntaxes if possible.
Great... code away. I would suggest a:
oracle_compat = true/false in the postgresql.conf
Yes I am kidding. The differences between
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Hans-Jürgen
Schönig) wrote:
I think it is important not to think in dogmas (in this case this
means SQL syntax is always better) - there should be a reasonable
compromise between compatibility and standard.
My compromise would be:
Neil Conway wrote:
Robert Treat wrote:
Actually i believe people want both syntax's as the former is used by
oracle and the latter by db2 (iirc)
I think the past consensus has been to adopt the SQL standard syntax. Is
there any reason to also support the Oracle syntax other than for
Robert Treat wrote:
Actually i believe people want both syntax's as the former is used by oracle
and the latter by db2 (iirc)
I think the past consensus has been to adopt the SQL standard syntax. Is
there any reason to also support the Oracle syntax other than for
compatibility? (And if that is
Christopher Kings-Lynne wrote:
I notice the CONNECT BY patch has been updated for 8.0:
http://gppl.moonbone.ru/
Seriously, we really need to get this into 8.1. Convert it to the
standard WITH RECURSIVE syntax if necessary...
Yep, we are just waiting for someone to do the work.
--
I notice the CONNECT BY patch has been updated for 8.0:
http://gppl.moonbone.ru/
Seriously, we really need to get this into 8.1. Convert it to the
standard WITH RECURSIVE syntax if necessary...
Chris
---(end of broadcast)---
TIP 6: Have you