plpgsql

From: Jie Liang <jliang(at)jliang(dot)ipinc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: plpgsql
Date: 2000-12-13 19:27:32
Message-ID: Pine.BSF.4.21.0012131121490.27861-100000@jliang.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

How can I declare an array in plpgsql??
when I use
declare
url text[10];
ERROR: parse error at or near "["
if I use
_text;
declare is OK, however, when I assgin a value after BEGIN
url[i]:=whatever;
get same ERROR,
Is it possible to return an array from a plpgsql function??

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stuart Statman 2000-12-13 19:38:18 RE: How to represent a tree-structure in a relational database
Previous Message Mathijs Brands 2000-12-13 19:22:24 Re: How to represent a tree-structure in a relational database