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) Is that what you're after? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
