Thanks, this is what I'm currently using and want to change from. This
table is taking a long time to insert data into and to extract. My
smallest table of this sort has 68000 rows. In comparison arrays are 10
times faster but lack the required tools to work with (especially for
multidimensional a
The example is below:
On Thu, 12 Oct 2000, Jean-Christophe Boggio wrote:
> Hi Indraneel,
>
> IM> I'm converting a complex flatfile where records are arranged serially.
> IM> some fields are as 'n' times repeating blocks of multiple lines. Some
> IM> subfields within these are also 'n' time repe
I'd like to do something like this:
create table value ( x int4 )
create index on value ( x )
create table filter (
op oid references pg_operator,
endpoint int4
)
select value.x
from value, filter
where value.x filter.op filter.endpoint
That is, I want the filter table to specify the oper
