From: | "Cristian Cappo A(dot)" <ccappo(at)cnc(dot)una(dot)py> |
---|---|
To: | Joe Conway <mail(at)joeconway(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: How access to array component |
Date: | 2003-07-22 14:19:29 |
Message-ID: | 3F1D0FB1.32016.60C3BA@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)cnc(dot)una(dot)py
tel. : 595-021-585550
fax : 595-021-585619
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-07-22 16:14:41 | Re: min() and NaN |
Previous Message | Michael Tibbetts | 2003-07-22 14:03:24 | Re: min() and NaN |