Re: How access to array component

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

In response to

Browse pgsql-sql by date

  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