> > 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
- [SQL] Variable-length Types Itai Zukerman
- Re: [SQL] Variable-length Types Josh Berkus
- Re: [SQL] Variable-length Types Tom Lane
- Re: [SQL] Variable-length Types Josh Berkus
- Re: [SQL] Variable-length Types KuroiNeko
- Re: [SQL] Variable-length Types Josh Berkus
- Re: [SQL] Variable-length Types Josh Berkus
- Re: [SQL] Variable-length Types Bruce Momjian
- Re: [SQL] Variable-length Types Itai Zukerman
- Re: [SQL] Variable-length Types DalTech - CTE