Subject: variable length arrays

From: [email-masked] (maureen noonan)
Date: Tue, 16 Mar 93 09:46:15 -0800

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

---

From: [email-masked] (Paul M. Aoki)
Date: Tue, 16 Mar 93 11:04:16 -0800

> Is there any way to have only one element in a variable

not under postgres 4.0.1.  you can under postgres <= 4.0 and >= 4.1.