Re: please help me with arrays - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: please help me with arrays
Date
Msg-id Pine.LNX.4.21.0010230020130.25851-100000@peter.localdomain
Whole thread Raw
In response to please help me with arrays  (Bo Berkhaut <bo@syntext.com>)
Responses Strange query results with dates  (Igor Khanjine <igor_kh@mailru.com>)
List pgsql-general
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 this you better redesign your
database schema to make "slots" a separate table.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Weird effects using BLOBs from libpq
Next
From: Sungchul Park
Date:
Subject: Re: duplicate key ? (fwd)