Re: curly braces to group outer joins in queries from OpenOffice.org?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: curly braces to group outer joins in queries from OpenOffice.org?
Date: 2003-11-11 14:39:52
Message-ID: 111.1068561592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
> I just tried using openoffice to create a SQL query, but it failed when I
> tried using left outer joins. The contructed query from OO contains curly
> braces to group things. I've never seen this construct before.

The SQL standard has never heard of it, either. Parentheses would be
correct here.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-11-11 15:56:19 Re: How to know column constraints via system catalog tables
Previous Message Christoph Haller 2003-11-11 13:10:38 Re: Getting the row_count value outside of a function