Joe
 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 

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 [EMAIL PROTECTED])

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

email: [EMAIL PROTECTED]
tel. : 595-021-585550
fax  : 595-021-585619


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to