"Josh Berkus" <[EMAIL PROTECTED]> writes:
>> What's the correct syntax to return two VARCHAR(255)?
> There isn't one. At this time, functions cannot return arrays.
Well, they *can*, it's just that there's no syntax to support
constructing an array value in SQL or plpgsql languages.
I know that you can do it in pltcl (there are examples in the pltcl
self-test), and of course you can do it in C. A brute-force solution
is to make a support function in one of those languages that takes two
varchars and returns an array of varchar.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
