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

Proposal: associative arrays for plpgsql (concept)

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Proposal: associative arrays for plpgsql (concept)
Date: 2005-06-29 15:59:26
Message-ID: Pine.LNX.4.44.0506291737460.18770-100000@kix.fsv.cvut.cz (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello

	The concept is from Oracle 9i, but with some changes.

http://www.oracle-10g.de/oracle_10g_documentation/appdev.101/b10807/05_colls.htm#i35672

Associative arrays are any arrays with index. Will be created 

DECLARE 
  x varchar[] INDEX BY VARCHAR = '{}'; -- some format, haven't idea

then I can use anywhere x[key];

two enhancing FOR cycle:

  -- iteration over all values
  FOR i IN VALUES OF x LOOP -- x array or associative array
  END LOOP;

  -- iteration over all keys
  FOR i IN INDICIES OF x LOOP -- x associatice array
    x[i]
  END LOOP;

new functions:

exists(x, key);
delete(x, key);

index is accessable only from PL/pgSQL. Associative arrays can be spec 
PostgreSQL type or clasic arrays with hash index. 

Comments, notes? 

Regards
Pavel Stehule


Responses

pgsql-hackers by date

Next:From: Affan Bin SalmanDate: 2005-06-29 16:21:20
Subject: Re: Implementing SQL/PSM for PG 8.2
Previous:From: Tom LaneDate: 2005-06-29 14:34:56
Subject: Re: Startup successful message, even on failure

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