X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 03B20D1B4ED for ; Tue, 11 Nov 2003 16:29:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 69687-10 for ; Tue, 11 Nov 2003 12:29:01 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 042DDD1B53F for ; Tue, 11 Nov 2003 12:29:01 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hABGSw19006998; Tue, 11 Nov 2003 11:28:58 -0500 (EST) To: Palle Girgensohn Cc: pgsql-sql@postgresql.org Subject: Re: curly braces to group outer joins in queries from OpenOffice.org? In-reply-to: <40060000.1068567321@rambutan.pingpong.net> References: <24750000.1068552259@rambutan.pingpong.net> <111.1068561592@sss.pgh.pa.us> <40060000.1068567321@rambutan.pingpong.net> Comments: In-reply-to Palle Girgensohn message dated "Tue, 11 Nov 2003 17:15:21 +0100" Date: Tue, 11 Nov 2003 11:28:57 -0500 Message-ID: <6997.1068568137@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/120 X-Sequence-Number: 15935 Palle Girgensohn 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