"Merlin Moncure" <[EMAIL PROTECTED]> writes:

> However, this would work:
> Create index on t(stackparam(array[a::text,b::text,c::text),
> array['char(2)', 'int', 'date')];

Well, I fear not all datatypes sort properly when treated as text. Notably
integers don't. "10" sorts before "2" for example. You could probably deal
with this with careful attention to each datatype you're converting if you're
interested in going to that length.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to