Re: please help me with arrays

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bo Berkhaut <bo(at)syntext(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: please help me with arrays
Date: 2000-10-22 22:22:23
Message-ID: Pine.LNX.4.21.0010230020130.25851-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://yi.org/peter-e/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sungchul Park 2000-10-23 02:04:41 Re: duplicate key ? (fwd)
Previous Message Tom Lane 2000-10-22 21:52:13 Re: Weird effects using BLOBs from libpq