Arrays in PL/pgSQL routines?

Поиск
Список
Период
Сортировка
От Ken Winter
Тема Arrays in PL/pgSQL routines?
Дата
Msg-id 005101c60c9f$cfb5f660$6603a8c0@kenxp
обсуждение исходный текст
Ответы Re: Arrays in PL/pgSQL routines?
Re: Arrays in PL/pgSQL routines?
Список pgsql-sql

Can arrays be declared in PL/pgSQL routines?  If so, how?

 

Section 8.10 of the documentation (http://www.postgresql.org/docs/7.4/static/arrays.html) tells how to declare and use arrays as table columns.  But I don’t find any part of the documentation that says how to declare a simple array local to a PL/pgSQL function.  I tried the following guess, but it only won me a “syntax error at or near VARCHAR:

 

DECLARE

  my_array VARCHAR [];

  …

 

~ TIA

~ Ken

В списке pgsql-sql по дате отправления: