| 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: | Whole Thread | Raw Message | 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 |