Received: from mailrelay2.inwind.it (mailrelay2.inwind.it [212.141.54.102]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7NF0RP87417 for ; Thu, 23 Aug 2001 11:00:27 -0400 (EDT) (envelope-from _casadei@libero.it) Received: from [62.98.225.245] (62.98.225.245) by mailrelay2.inwind.it (5.5.029) id 3B83ABF000044D68 for pgsql-sql@postgresql.org; Thu, 23 Aug 2001 17:00:14 +0200 Received: (qmail 2386 invoked by uid 1000); 23 Aug 2001 14:58:30 -0000 Date: Thu, 23 Aug 2001 16:58:30 +0200 From: Francesco Casadei To: pgsql-sql@postgresql.org Subject: Function returning an array Message-ID: <20010823165830.A2359@goku.kasby> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Operating-System: FreeBSD 4.4-RC i386 X-Archive-Number: 200108/291 X-Sequence-Number: 4537 I want a function to return an array of two VARCHAR(255). This works, but does not return VARCHAR(255): CREATE FUNCTION ins_div(CHAR(8)) RETURNS _varchar AS '...' LANGUAGE 'plpgsql'; These don't work: CREATE FUNCTION ins_div(CHAR(8)) RETURNS _varchar(255) AS '...' LANGUAGE 'plpgsql'; CREATE FUNCTION ins_div(CHAR(8)) RETURNS varchar(255)[2] AS '...' LANGUAGE 'plpgsql'; CREATE FUNCTION ins_div(CHAR(8)) RETURNS varchar[2](255) AS '...' LANGUAGE 'plpgsql'; CREATE FUNCTION ins_div(CHAR(8)) RETURNS setof varchar(255) AS '..' LANGUAGE 'plpgsql'; What's the correct syntax to return two VARCHAR(255)? Francesco Casadei