Received: from flex.flex.ro (ns.flex.ro [193.230.255.2]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f64D2Za87001; Wed, 4 Jul 2001 09:02:43 -0400 (EDT) (envelope-from teo@flex.ro) Received: from flex.ro (teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.11.0/8.11.0) with ESMTP id f64D2Qe14421; Wed, 4 Jul 2001 16:02:38 +0300 Message-ID: <3B4313CA.FE04D0BA@flex.ro> Date: Wed, 04 Jul 2001 16:02:02 +0300 From: Constantin Teodorescu Organization: PCNet Braila X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: David Stanaway , pgsql-sql@postgresql.org, pgsql-interfaces@postgresql.org Subject: Re: Re: [SQL] indexing arrays in pgaccess's query interface is failing References: <18354.994171319@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/18 X-Sequence-Number: 1771 Tom Lane wrote: > > [ redirected to pgsql-interfaces, which seems a more appropriate venue ] > > David Stanaway 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. Got the message! I'll fix the Query builder to quote []'s! Teo