Mike Charnoky wrote: > OK, forgive my ignorance here, but the maintainer of our custom data > type code is no longer with us and this is new territory for me. We do > have a function which takes our custom data type and returns a cstring. > Is there a pg function which converts a cstring to text type? This > seems to be the missing link to eventually get the data to float4[]. Sure, textin() does that. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J "Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?" ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match