Skip site navigation (1) Skip section navigation (2)

Re: [SQL] indexing arrays in pgaccess's query interface is failing

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 (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-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

In response to

Responses

pgsql-interfaces by date

Next:From: Barry LindDate: 2001-07-03 15:18:03
Subject: Re: [INTERFACES] New code for JDBC driver
Previous:From: David StanawayDate: 2001-07-03 09:05:05
Subject: indexing arrays in pgaccess's query interface is failing

pgsql-sql by date

Next:From: Ross J. ReedstromDate: 2001-07-03 14:47:09
Subject: Re: pls Help us... (sql question)
Previous:From: Jeff EckermannDate: 2001-07-03 14:08:20
Subject: RE: How do I print a message in a function?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group