Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id B4640632E10
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  6 Mar 2010 07:04:29 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 36327-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  6 Mar 2010 11:04:13 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f228.google.com (mail-bw0-f228.google.com
	[209.85.218.228])
	by mail.postgresql.org (Postfix) with ESMTP id AF310632D3B
	for <pgsql-sql@postgresql.org>; Sat,  6 Mar 2010 07:04:18 -0400 (AST)
Received: by bwz28 with SMTP id 28so1370725bwz.34
	for <pgsql-sql@postgresql.org>; Sat, 06 Mar 2010 03:04:16 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:subject:content-type
	:content-transfer-encoding;
	bh=PMzaEWQAw4oI5NImZfpl8PtsDCRY5rqfMcvbw7jZH1Y=;
	b=Cif7kvqfYIJhuq9OxwRmolEhcBL/n2D2RgjtuH/d6ZUn7630u5YxbVMQDtslcuo/LG
	r5Ruk3Cu8Ey3jJAUr42yZMLvGE7Qj35cXHlAkyLYRNRGFV1T0wUJr2CfX2A3kecccvl1
	A4WGJNnbzGgpFdrJ/PL3AMcmF9w1ZUpUQ2abs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	b=SOeNYXtENjELNhAXRjS6lo/j/JPSI3nf9v3LjIgfUFRtw9lYxg1owBN+ak48Xplt2e
	vQpHCAKxO9IHF4YeaI+7UAs412OOOcvMqdUv44I6KPh1hUaDtG5D1/6Vj+nUiF9WbAwZ
	XOZ+kvuHnjrrExfnMksoliRHQsorc8thc3iDk=
Received: by 10.204.36.70 with SMTP id s6mr1493434bkd.22.1267873454355;
	Sat, 06 Mar 2010 03:04:14 -0800 (PST)
Received: from [192.168.1.128] (net-93-144-32-214.t2.dsl.vodafone.it
	[93.144.32.214])
	by mx.google.com with ESMTPS id 14sm360969bwz.2.2010.03.06.03.04.12
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Sat, 06 Mar 2010 03:04:13 -0800 (PST)
Message-ID: <4B9236A8.3070603@gmail.com>
Date: Sat, 06 Mar 2010 12:04:08 +0100
From: Gianvito Pio <pio.gianvito@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; it;
	rv:1.9.1.8) Gecko/20100216 Thunderbird/3.0.2
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Check type compatibility
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.462 tagged_above=-10 required=5 tests=AWL=-0.277,
	BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 201003/39
X-Sequence-Number: 33746

Hi all,
is there a way to check if two attribute are type compatible (for 
example integer and serial, integer and integer, character varying and 
text, etc..)?

Example:
IF (compatible (table1.att1, table2.att2)) THEN
         ...
ELSE
         ...
END IF;

Thanks