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
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] fro
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.
> >
>
>
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)
Hello
How access to especific array component
of an function with return type _varchar
declaration of my function:
>>> create or replace __function( int2, int2 ) returns _varchar
now use the function in SQL and access to the element 1...
>>> select __function(10::int2, 20::int2)[1]
