Skip site navigation (1) Skip section navigation (2)

Re: Re[2]: [pgsql-ru-general] оп

From: Sergey Suleymanov <solt(at)eatpbank(dot)ru>
To: PostgreSQL on Russian <pgsql-ru-general(at)postgresql(dot)org>
Subject: Re: Re[2]: [pgsql-ru-general] оп
Date: 2006-01-16 05:39:29
Message-ID: 87irsk3f5a.fsf@boo.eatpbank.ru (view raw or flat)
Thread:
Lists: pgsql-ru-general
>>>>> Serik Akhmetov writes:

 Serik> CREATE OR REPLACE FUNCTION test1() RETURNS text AS' declare t
 Serik> int4[] ; ret text; begin

 Serik>  t[0] := 100; t[1] := 200;

 Serik>  select array_dims(t) into ret; return ret;
 
 Serik> end' LANGUAGE 'plpgsql' VOLATILE;

 Serik>   возвращает пустую строку. Что сделал не правильно ?

          Надо инициировать массив.
declare 
  t int4[] := ''{}'';

-- 
  Sergey Suleymanov

In response to

pgsql-ru-general by date

Next:From: DmitryDate: 2006-01-17 17:07:34
Subject: нумерация строк при выводе селекта
Previous:From: Markus BertheauDate: 2006-01-15 06:55:57
Subject: Re: Re[2]: [pgsql-ru-general]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group