Thomas Hallgren <[EMAIL PROTECTED]> writes: > Ok, so there are two 'optional' arguments. Following my suggestion, the > input and receive function would always take 3 arguments. Then, it's up > to the function as such if it makes use of them or not. Do you see any > problem with that?
(1) backwards compatibility (2) inability to ever add a fourth optional argument without creating a flag day for everyone I'm all for cleaning up the handling of shell types (and in fact have had that on my personal TODO list for ages). But I see zero if not negative usefulness in these ideas about changing CREATE TYPE. The certain outcome of that is to import all the complications of CREATE FUNCTION into CREATE TYPE, and for what gain? > So which is it? > CREATE TYPE complex; > CREATE TYPE complex AS SHELL; > DECLARE TYPE complex; I'd go with the first. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: 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