Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA12921; Fri, 13 Dec 91 14:11:01 -0800
Message-Id: <9112132211.AA12921@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: Dynamic Loader for Sparks
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Thu, 12 Dec 91 18:11:24 PST."
             <9112130219.AA03037@postgres.Berkeley.EDU> 
Date: Fri, 13 Dec 91 14:10:47 PST

you write:
> 
> Two questions:
> 
> 	We are running postgres v3r1 on sparkstation IPCs.  Does the lack
> of a dynamic loader mean that we will be unable to write user defined
> function in C?

The dynamic loader for the sparc port should work on your sparc IPC.

>  	Second, without user defined functions how can one retrieve all
> elements of postgres base type arrays.  IE. given the following class:
> 
>         emp (name = char16, age = int4, salary = in4[12])
> 
> How can I retrieve all 12 elements of salary for a given instance?

all array functionality is built into the postgres dbms.  To retrieve the
entire array you can do either:

	retrieve (emp.salary)

or

	retrieve (emp.salary[1], emp.salary[2], ..., emp.salary[12])


Jeff Meredith
mer@postgres.berkeley.edu