Re: get array data with range

From: CoL <col(at)mportal(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: get array data with range
Date: 2002-01-29 15:23:07
Message-ID: 3C56BE5B.9080509@mportal.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

> second question.
> 2. which are better (from speed and size side)?
> i make "one" table with array like this
> TABLE mytable
> mytable_id | array_data
> -------------------------------------
> 1 | {1,2,...,100000}
> 2 | {1,2,...,100000}
> 3 | {1,2,...,100000}
> ....
>
> or like this one, many table but no array
> TABLE mytable_1
> was_array_data
> ----------------
> 1
> 2
> ...
> 100000
if you have only these numbers in array better to use more tables with
an int,
cause it can be indexed and fast selected.

CoL

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alla 2002-01-29 19:14:07 What's wrong with this function - "returns setof"
Previous Message Johny Jugianto 2002-01-29 11:02:34 get array data with range