Re: How access to array component - Mailing list pgsql-sql

From Joe Conway
Subject Re: How access to array component
Date
Msg-id 3F1CC71B.4070309@joeconway.com
Whole thread Raw
In response to Re: How access to array component  ("Cristian Cappo A." <ccappo@cnc.una.py>)
Responses Re: How access to array component  ("Cristian Cappo A." <ccappo@cnc.una.py>)
List 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



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: min() and NaN
Next
From: Wolfgang Slany
Date:
Subject: Re: "Truncate [ Table ] name [Cascade]"?