Received: from zukerman-1.dsl.speakeasy.net (zukerman-1.dsl.speakeasy.net [216.254.75.142]) by hub.org (8.10.1/8.10.1) with ESMTP id e9FKw5R02331 for ; Sun, 15 Oct 2000 16:58:05 -0400 (EDT) Received: from (matt.w80.math-hat.com) [216.254.75.141] by zukerman-1.dsl.speakeasy.net with esmtp (Exim 3.12 #1 (Debian)) id 13kul1-000393-00; Sun, 15 Oct 2000 16:51:47 -0400 Received: from zukerman by matt.w80.math-hat.com with local (Exim 3.16 #1 (Debian)) id 13kur7-0006yP-00 for ; Sun, 15 Oct 2000 16:58:05 -0400 To: sqllist Subject: Re: Variable-length Types References: <871yxi432t.fsf@matt.w80.math-hat.com> <39E9F80C.D9BE2054@agliodbs.com> <5470.971641584@sss.pgh.pa.us> From: Itai Zukerman Date: 15 Oct 2000 16:58:05 -0400 In-Reply-To: Tom Lane's message of "Sun, 15 Oct 2000 16:26:24 -0400" Message-ID: <87bswl255u.fsf@matt.w80.math-hat.com> Lines: 12 User-Agent: Gnus/5.0807 (Gnus v5.8.7) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200010/135 X-Sequence-Number: 1797 > > 3. What sort of trouble am I going to get into trying to pull data from > > a custom type into an external interface (i.e. PHP4)? > > Good question --- the interface code might or might not have a sensible > default behavior for types it doesn't recognize. Why not explicitly convert to text? (I assume the output function for that type will be used in the conversion...?). SELECT phone_num::text FROM tab -itai