Re: [GENERAL] please help me with arrays

2000-10-22 Thread Peter Eisentraut
Bo Berkhaut writes: > CREATE TABLE example (name text, slots text[]); > > I want to be able to select, for example, all rows such that an element > of example.slots exists equal to example.name. There are some operators for this in contrib/array. However, I'd say that if you're trying to do thi

[GENERAL] please help me with arrays

2000-10-22 Thread Bo Berkhaut
Hi! Would you please explain me how can I express in PostgreSQL the notion of "any element of the array". Having a table like: CREATE TABLE example (name text, slots text[]); I want to be able to select, for example, all rows such that an element of example.slots exists equal to example.name. So