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