Received: from richter.hu ([194.143.226.4]) by hub.org (8.9.3/8.9.3) with SMTP id EAA17538 for ; Mon, 20 Sep 1999 04:31:38 -0400 (EDT) (envelope-from molnar.laszlo@richter.hu) Received: from richter.hu by richter.hu;Mon, 20 Sep 1999 08:32:44 GMT Sender: root Message-ID: <37E34FC1.CF42D25E@richter.hu> Date: Sat, 18 Sep 1999 10:39:29 +0200 From: Molnar Laszlo X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.2.5 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: [SQL] input function problem for user type array Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, I have some problem with my user type array. I have defined the following: CREATE FUNCTION atom_in(opaque) RETURNS atom AS '/var/lib/pgsql/i_o/atom_input.so' LANGUAGE 'c'; CREATE FUNCTION atom_out(opaque) RETURNS opaque AS '/var/lib/pgsql/i_o/atom_input.so' LANGUAGE 'c'; CREATE TYPE atom ( internallength = 60, input = atom_in, output = atom_out ); CREATE TYPE molecule ( internallength = variable, element = atom, input = atom_in, output = atom_out ); CREATE TABLE mols (mol molecule); My question is: do i need an input function for my array type (molecule) or the array_in function call my input function (atom_in) for every array element successively? Where can I see an example for user defined array type input and output functions? Thanx in advance for the answers, Laszlo Molnar GEDEON RICHTER Ltd. HUNGARY