Good reason. Now I'm excited. I'll download and run tests and try to do a write up in general bits next week.
cheers, elein On Sat, Jun 05, 2004 at 05:00:24PM -0400, Tom Lane wrote: > I wrote: > > regression=# insert into bar values (row(row(1.1, 2.2), row(3.3, 4.4))); > > BTW, I forgot to mention that the keyword ROW is optional as long as > you've got at least two items in the row expression, so the above can > be simplified to > > regression=# insert into bar values (((1.1, 2.2), (3.3,4.4))); > INSERT 155011 1 > > Some other examples: > > regression=# select (1,2)::complex; > ERROR: output of composite types not implemented yet > regression=# select cast ((1,2) as complex); > ERROR: output of composite types not implemented yet > > Looking at these, it does seem like it would be natural to get back > > complex > --------- > (1,2) > > so I'll now agree with you that the I/O syntax should use parens not > braces as the outer delimiters. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster