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

PgAccess and arrays

From: Spirou <spirou(at)carolo(dot)net>
To: pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: PgAccess and arrays
Date: 1999-08-11 05:23:23
Message-ID: 37B108CB.842CC5C7@carolo.net (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-interfaces
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

In response to

pgsql-announce by date

Next:From: Tom LockhartDate: 1999-08-11 20:47:11
Subject: We won!
Previous:From: Druart LaurentDate: 1999-08-10 08:06:44
Subject: (pas d'objet)

pgsql-interfaces by date

Next:From: Constantin TeodorescuDate: 1999-08-11 06:26:23
Subject: libpgtcl and array fields return format - PROPOSAL
Previous:From: Brett W. McCoyDate: 1999-08-10 21:56:48
Subject: Re: [INTERFACES] Web, PostgreSQL, C

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