Re: record datatype comparisons - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: record datatype comparisons
Date
Msg-id 20061031214927.GF12008@alvh.no-ip.org
Whole thread Raw
In response to Re: record datatype comparisons  ("George Pavlov" <gpavlov@mynewplace.com>)
Responses Re: record datatype comparisons  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: record datatype comparisons
Next
From: Volkan YAZICI
Date:
Subject: Re: record datatype comparisons