Hi
AFAK jdbc 3.0 requires driver to support curly braces for escape sequences.
For example:
{d yyy-mm-dd}
{t hh:mm:ss}
{ts -mm-dd hh:mm:ss[.f...]}
{oj outer-join}
{fn scalar-function}
Chapter 6.2 states that drivers must support escape syntax.
Chapter 13.4 defines escape syntax.
http://java
Palle Girgensohn <[EMAIL PROTECTED]> writes:
> Only, I set up postgreql to connect using JDBC... :(
> So, the bug is that OO expects an ODBC connection, and I use JDBC... Seems
> logical. I'll go ask the ODBC guys. Thanks for you help,
I do not know if the JDBC spec includes ODBC-style brace cons
Only, I set up postgreql to connect using JDBC... :(
So, the bug is that OO expects an ODBC connection, and I use JDBC... Seems
logical. I'll go ask the ODBC guys. Thanks for you help,
/Palle
--On tisdag, november 11, 2003 11.28.57 -0500 Tom Lane <[EMAIL PROTECTED]>
wrote:
Palle Girgensohn <[
Palle Girgensohn <[EMAIL PROTECTED]> 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::OUSt
What about the `OJ'?
FROM ( OJ table alias left join table2 alias2 )
OJ seems plain wrong, right?
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 ");
Palle Girgensohn <[EMAIL PROTECTED]> 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 o
Hi!
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. Is it OO
doing bad things, or does postgresql not understand it? It's on pg-7.3.
