indexing arrays in pgaccess's query interface is failing

From: David Stanaway <david(at)netventures(dot)com(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: indexing arrays in pgaccess's query interface is failing
Date: 2001-07-03 09:05:05
Message-ID: E15HMZC-0004Wc-00@runt.in.netventures.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

Hi there, I am having some difficulties with using arrays in pgaccess
relating to arrays.

Here is an example schema:

CREATE TABLE arraykeys (
akID int,
akName varchar(12),
PRIMARY KEY(akID)
);

CREATE TABLE items (
itID serial,
itProperties bool[],
PRIMARY KEY(itID)
);

--.. And some Data

INSERT INTO arraykeys VALUES (1,'Active');
INSERT INTO arraykeys VALUES (2,'Overdue');
INSERT INTO arraykeys VALUES (3,'Local');

INSERT INTO items (itProperties) VALUES ( '{1,0,1}');
INSERT INTO items (itProperties) VALUES ( '{0,1,1}');

--.. And now the query that I am having problems with.

SELECT itID, itProperties[akID], akName
FROM items, arraykeys;

In the readline client psql, the above select statement works perfectly
scratch-# FROM items, arraykeys;
itid | itproperties | akname
------+--------------+---------
1 | t | Active
1 | f | Overdue
1 | t | Local
2 | f | Active
2 | t | Overdue
2 | t | Local
(6 rows)

However

In pgaccess,
when I try to execute the same query in query builder,
I get the tcl error dialogue:
Error: invalid command name "akID"

Is there an alternate way indexing arrays in queries that I should be
using?
Or is pgaccess just not suitable for this class of queries!

--
Best Regards
David Stanaway
========================.---------------------------------------------
Technology Manager - Australia's Premier Internet Broadcasters
david(at)NetVentures(dot)com(dot)au Office +612 9357 1699
========================'---------------------------------------------

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2001-07-03 14:41:59 Re: [SQL] indexing arrays in pgaccess's query interface is failing
Previous Message Denis Gasparin 2001-07-03 08:33:23 PyGreSQL pg.error Exception

Browse pgsql-sql by date

  From Date Subject
Next Message datactrl 2001-07-03 12:44:44 problem with date/time constants
Previous Message Markus Wagner 2001-07-03 06:46:13 traversing foreign key relationships between tables