plpgsql - Mailing list pgsql-sql

From Jie Liang
Subject plpgsql
Date
Msg-id Pine.BSF.4.21.0012131121490.27861-100000@jliang.ipinc.com
Whole thread Raw
In response to Re: SQL parse error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses arrays in PostgreSQL
List 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@ipinc.com
www.ipinc.com




pgsql-sql by date:

Previous
From: Frank Mingan You
Date:
Subject: Query by sresultset.getArray(index)
Next
From: "Stuart Statman"
Date:
Subject: RE: How to represent a tree-structure in a relational database