From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | David Stanaway <david(at)netventures(dot)com(dot)au> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [SQL] indexing arrays in pgaccess's query interface is failing |
Date: | 2001-07-03 14:41:59 |
Message-ID: | 18354.994171319@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
[ redirected to pgsql-interfaces, which seems a more appropriate venue ]
David Stanaway <david(at)netventures(dot)com(dot)au> writes:
> --.. And now the query that I am having problems with.
>
> SELECT itID, itProperties[akID], akName
> FROM items, arraykeys;
>
> In pgaccess,
> when I try to execute the same query in query builder,
> I get the tcl error dialogue:
> Error: invalid command name "akID"
Someone isn't quoting the query string correctly on the Tcl side ---
[akID] is Tclese for command substitution. Sounds like pgaccess expects
the user to quote command punctuation characters that should be passed
through. Not sure if that should be regarded as a bug or a feature.
It could be considered a feature that you can enter SQL commands with
Tcl command substitution performed on them, but it's something that
would confuse non-Tcl-users a lot.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2001-07-03 15:18:03 | Re: [INTERFACES] New code for JDBC driver |
Previous Message | David Stanaway | 2001-07-03 09:05:05 | indexing arrays in pgaccess's query interface is failing |
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2001-07-03 14:47:09 | Re: pls Help us... (sql question) |
Previous Message | Jeff Eckermann | 2001-07-03 14:08:20 | RE: How do I print a message in a function? |