[EMAIL PROTECTED] (Tom Lane) wrote: > The cure is to cast the literal to some specific type when you > do the CREATE.
I figured that was the case, and pointed that cure back to the developer. What I was hoping to hear was some way of coercing the data into a more usable type after the fact. The query is actually generating a TEMP table, so the cast is certainly the right answer. -- output = reverse("gro.mca" "@" "enworbbc") http://www.ntlug.org/~cbbrowne/emacs.html "In the case of CAPP, an EAL4 evaluation tells you everything you need to know. It tells you that Microsoft spent millions of dollars producing documentation that shows that Windows 2000 meets an inadequate set of requirements, and that you can have reasonably strong confidence that this is the case." -- Jonathan S. Shapiro ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org