Re: [GENERAL] questing using array

1999-10-13 Thread Peter Eisentraut
You might want to look into the contrib/array directory which has _some_ helpers with arrays. But in general, using arrays in cases like yours is a bad idea because, a) It has nothing to do with relational database design b) Arrays were not designed for this kind of stuff, so you won't get very f

[GENERAL] questing using array

1999-10-12 Thread Kevin Heflin
Just trying to get a handle on how to work with an array as a datatype. For exampel I set up a table: namevarchar (20), ageids int4[] Made an INSERT like: insert into TABLENAME (name, ageids) values ('test', '{1, 2, 3, 4}'); What I haven't been able to figure out is how to do a sele