"Daniel Verite" <dan...@manitou-mail.org> writes: > To avoid the confusion between "2:4" and "2":"4" or 2:4, > and the ambiguity with a possibly existing "2:4" column, > maybe we should abandon this syntax and require the optional > scolH to be on its own at the end of the command.
That would be OK with me; it's certainly less of a hack than what's there now. (I went back and forth about how much effort to put into dealing with the colon syntax; I think the version I have in my patch would be all right, but it's not perfect.) > The simplified invocation of the command would be > \crosstabview colV colH colD [scolH] > (without any default, just scolH being optional): > Or if it's preferrable to have colH just near scolH: > \crosstabview colD colV colH [scolH] Uh, why not \crosstabview [ colV colH [ colD [ scolH ]]] I see no particular reason that the existing abbreviation styles aren't good. In any case, forcing colD to be specified is kind of annoying ... regards, tom lane -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers