pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: NosyMan <nosyman@gmail.com>
To: pgsql-sql@postgresql.org
Subject: How to iterate through arrays?
Date: Wed, 9 Feb 2005 15:59:08 +0200
Message-ID: <200502091559.08997.nosyman@gmail.com> (raw)

Hi there,

I'm trying to iterate through arrays in PL/PGSQL:
....
	DECLARE
		update_query CHAR;
		update_query_params CHAR ARRAY[6];
	BEGIN
			update_query_params[1]:='some text';		
			
			RAISE NOTICE 'Testing element %', update_query_params[1];
	END
.....


It does not 'compile'... :-(. Can you tell me what is the problem?

Thanks,
Nosy



view thread (4+ messages)  latest in thread

Message-ID: <200502091559.08997.nosyman@gmail.com>
Permalink:  ../200502091559.08997.nosyman@gmail.com/
Also on:    postgresql.org/message-id/200502091559.08997.nosyman@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: nosyman@gmail.com
  Subject: Re: How to iterate through arrays?
  In-Reply-To: <200502091559.08997.nosyman@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox