Re: [SQL] How access to array component

[Joe Conway]

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])