Re: How access to array component

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Cristian Cappo A(dot)" <ccappo(at)cnc(dot)una(dot)py>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How access to array component
Date: 2003-07-22 05:09:47
Message-ID: 3F1CC71B.4070309@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Cristian Cappo A. wrote:
> Tried, but...
> >> select (foo(10::int2,20::int2))[1];
> >> ERROR: parser: parse error at or near "[" at character 32
>
> I'm using the version 7.3.3

Sorry, it works on 7.4devel, so I thought it might on 7.3 as well. In
any case, this works on 7.3.3:

test=# select f1[1] from (select foo(10::int2, 20::int2) as f1) as ss;
f1
----
1
(1 row)

HTH,

Joe

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-07-22 06:09:09 Re: min() and NaN
Previous Message Bruce Momjian 2003-07-22 01:34:43 Re: min() and NaN