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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lockhart | 1999-08-11 20:47:11 | We won! |
Previous Message | Druart Laurent | 1999-08-10 08:06:44 | (pas d'objet) |
From | Date | Subject | |
---|---|---|---|
Next Message | Constantin Teodorescu | 1999-08-11 06:26:23 | libpgtcl and array fields return format - PROPOSAL |
Previous Message | Brett W. McCoy | 1999-08-10 21:56:48 | Re: [INTERFACES] Web, PostgreSQL, C |