Thread: PgAccess - 0.97b released

Hello everybody,

With the help of Ross Reedstrom and Kris Klindworth there is available
at

ftp://ftp.flex.ro/pub/pgaccess/pgaccess-0.97b.tcl.gz

a 45Kb gzipped prerelease of 0.97

New features:
- support for internationalization (Teo)
- better moving between records using keyboard (Kris)
- save/restore visual query layout (Ross)
- schemas (Ross)

Internationalization is achieved my moving all (most) of the messages in
a associative array called Messages that can be found right at the
begining of the program. Messages are translated for the moment in
romanian and in a ugly, ugly, horrible french :-) (a french friend
Delafond will try to correct it). For the moment changes between
preferred languages should be made directly into the source (set
pref(language) italian) and in ~/.pgaccessrc.

Other translations will be easy to add, I'll wait for volunteers.

This prerelease should be tested, I'll wait for bug reports. I hope that
in a week it should be polished enough so final translations should be
added for french and german.

Best regards,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

It seems that pgAccess has as much trouble as I have with arrays ...
and perhaps more since I can't even run the queries below in it.

Does anyone have information on those damned arrays ?

Here is the text of a message I have posted on NOVICE
without success up to now.

********************************

I'd like to make some selections on values in arrays.
I know I could use a more 'SQL-correct' way to achieve this.
(create another table, link it to the first one and so on.)
But I was playing with arrays and I was wondering ... 

I give an exemple to make my question clear (I hope)

let's say I store some values in a 2 dim array :
       create table myfunction (               id      int4,               name    text,               args
text[][]);
       insert into myfunction       values( 1,               'func1',               '{{"key1", "value1"}, {"key2",
"value2"}}');      insert into myfunction       values( 2,               'func2',               '{{"key1", "value1"},
{"key2","value5"}, {"key3",
 
"value2"}}');
everything's OK.

I can store my values.
I can retrieve them :       select args from myfunction where name = 'func1';
or       select myfunction.args[1][2] where id = 2;
or even       select myfunction.args[1:1][1:2] where id = 2;
with some trial & errors it works.

But I can't manage to look into myfunction.args,
I mean something like       select name from myfunction        where myfunction.args [][2] = 'value2';
or       select name from myfunction        where myfunction.args ~~ '%value2%';
if I don't know where is value2 in my array (if it exists).
Which operators can I use ?
How can I inspect an array-field ?

Any information on arrays would be welcome.


-- 
Spirou
Un club Linux pour les Carolos -->
http://carolo.net/carolinux/index.html