On Oct 31 06:49, Alvaro Herrera wrote: > George Pavlov wrote: > > thanks fo the reply. i was misled by pgAdmin (1.6) giving both as > > "record" in the datatype (i thought "row" and "?column?" were just "best > > guess" column headers). > > > > so, if they are indeed differently shaped is there any way to make them > > be the same shape? > > > > note that this one also fails with the same error (one would think these > > are the "same shape"): > > > > select > > (select (1,2)) > > is distinct from > > (select (1,2)) > > ; > > This one works: > > alvherre=# select > row(1,2) > is distinct from > row(1,2) > ; > ?column? > ---------- > f > (1 fila)
What's the difference between "SELECT (1, 2);" and "SELECT ROW(1, 2);"? Regards. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
