Re: [PORTS] Port Bug Report: select of array columns

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Michael Tomuschat <michael(at)knoto(dot)tuebingen(dot)com>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] Port Bug Report: select of array columns
Date: 1999-02-11 14:50:04
Message-ID: 36C2EE1C.4D5ED664@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

> michael=> select * from test where 1 = test.fil_arr[1];
> art_id|fil_arr
> ------+---------
> 1|{1,2,3,4}
> (1 row) -- shouldn't the array - index start with 0?

The array index is one-based. This is a documented feature, and is
consistant with other index numbering (such as arguments to substring())
in SQL92.

> michael=> select fil_arr[1] from test; -- should be possible, too
> ERROR: type name lookup of fil_arr failed

On my list of things to look at, though I haven't yet done it so if
someone else wants to pick it up it's available. Reported earlier by
Oliver.

- Tom

In response to

Browse pgsql-ports by date

  From Date Subject
Next Message Unprivileged user 1999-02-12 13:54:02 Port Bug Report: configure crashes trying to include "conftest.sh" if current dir is not in PATH
Previous Message Unprivileged user 1999-02-11 13:45:45 Port Bug Report: select of array columns