Re: How access to array component

JoeTried, 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 

Thanks..
---

> Cristian Cappo wrote:
> >  >>>  select __function(10::int2, 20::int2)[1]
> >                       ^^^ parsing error.
> > 
> 
> Try:
> 
> create or replace function foo(int2, int2 ) returns _varchar as '
> select ''{1,2}''::_varchar
> ' language 'sql';
> 
> regression=# select (foo(10::int2, 20::int2))[1];
>   foo
> -----
>   1
> (1 row)
> 
> HTH,
> 
> Joe
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

------------------------------------
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