arrays in pl/pgsql - Mailing list pgsql-sql

From Michael Shapiro
Subject arrays in pl/pgsql
Date
Msg-id 200312160339.hBG3d0q31028@osage.ncsa.uiuc.edu
Whole thread Raw
Responses Re: arrays in pl/pgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Is it possible in pl/pgsql to declare and then assign to arrays?
For example if I declare an array as follows
DECLARE    dn text[];

How do I assign the first element to a string (say 'a').
I have tried the following (which doesn't work)
dn[1] := \'a\';

The parser doesn't like the [ that follows dn.




pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: NOT-IN CLAUSE
Next
From: Tom Lane
Date:
Subject: Re: arrays in pl/pgsql