Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA12195; Tue, 16 Mar 93 09:46:15 -0800
Date: Tue, 16 Mar 93 09:46:15 -0800
Message-Id: <9303161746.AA12195@postgres.Berkeley.EDU>
From: noon@lamont.ldgo.columbia.edu (maureen noonan)
Subject: variable length arrays
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu




Is there any way to have only one element in a variable
length array??


Go
* create GRVrov_DSC (param_list=text[])\g
 
Query sent to backend is "create GRVrov_DSC (param_list=text[])"
CREATE


Go
* append GRVrov_DSC (param_list="{"field_1"}")\g
 
Query sent to backend is "append GRVrov_DSC (param_list="{"field_1"}")"
APPEND 1123888


Go
* retrieve (GRVrov_DSC.all)\g

Query sent to backend is "retrieve (GRVrov_DSC.all)"
---------------
| param_list  |
---------------
| {}          |
---------------


Go
* append GRVrov_DSC (param_list="{"field_1","field_2"}")\g
 
Query sent to backend is "append GRVrov_DSC (param_list="{"field_1","field_2"}")"
APPEND 1123889


Go
* retrieve (GRVrov_DSC.all)\g
 
Query sent to backend is "retrieve (GRVrov_DSC.all)"
---------------
| param_list  |
---------------
| {}          |
---------------
| {"field_1","field_2"}|
---------------


Thank you,
Maureen Noonan