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 16:28:57
Message-ID: 6997.1068568137@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:
> Here's their code snippet (from
> oo_1.1_src/dbaccess/source/ui/querydesign/QueryDesignView.cxx):

> if(aJoin.getLength())
> {
> ::rtl::OUString aStr = ::rtl::OUString::createFromAscii("{ OJ ");
> aStr += aJoin;
> aStr += ::rtl::OUString::createFromAscii(" },");
> aTableListStr += aStr;
> }

Now that I look at it, I bet that they are expecting the ODBC driver to
translate "{ OJ ... }" into the appropriate syntax for the database
(either SQL standard or not, depending on the DB :-().

There are a number of ODBC brace-constructs that our driver knows how to
translate, but I don't think that's one of them. You should bug the
ODBC guys about it.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Palle Girgensohn 2003-11-11 16:32:06 Re: curly braces to group outer joins in queries from
Previous Message Holger Jakobs 2003-11-11 16:24:36 Re: transaction processing after error in statement