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

From Cristian Cappo A.
Subject Re: How access to array component
Date
Msg-id 3F1D0FB1.32016.60C3BA@localhost
Whole thread Raw
In response to Re: How access to array component  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
Thanks Joe..

------
On 21 Jul 2003 at 22:09, Joe Conway wrote:

> 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

------------------------------------
Cristian Cappo Araujo
Desarrollo de Proyectos - Direccion Tecnica
Centro Nacional de Computación
Universidad Nacional de Asunción

email: ccappo@cnc.una.py
tel. : 595-021-585550
fax  : 595-021-585619



pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: time delay function
Next
From: Bruce Momjian
Date:
Subject: Re: min() and NaN