Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 84E096326E2 for ; Sun, 2 May 2010 23:12:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 37918-05 for ; Mon, 3 May 2010 02:12:38 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 44DD7632574 for ; Sun, 2 May 2010 23:12:40 -0300 (ADT) Received: by gyg13 with SMTP id 13so932118gyg.19 for ; Sun, 02 May 2010 19:12:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:from:date :message-id:subject:to:content-type; bh=HoN2q6oqQfD4H8AkTT1pYaQf6DeFCO+zzcql3nt7W9s=; b=hHQ1z/gz7KwUjQwMAVQdhJbnzrgR04gFLcLruchm8yl7R6LlKuYvlhB6e4CEG00KRj DATJTO1P7VjQwoXLelbJniuUFsT+LVGLPqs7U9ErBC8MHDNckLWxkE5wGE+3uhUYIb/l 9/wmjo34prIIgLwtdyL+Yr8wTHb0qXdpI9bNU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=YarMH8o+052LyUN8u+R00u7H6kk8Wt0otY6qgOs2j79LIjYnOOzsY3WLbVxS5x1+2a sS0PaoIEmr3cEps12/BHxAKr/qyW7bCOzraIBSpcQnmtAm22YBKfQd5oloqsz3aWnhoG cdMOJZI25qgqeGLL+5MwfAoyQte2PEkucdeGo= Received: by 10.101.164.17 with SMTP id r17mr1478487ano.230.1272852758177; Sun, 02 May 2010 19:12:38 -0700 (PDT) MIME-Version: 1.0 Received: by 10.100.7.11 with HTTP; Sun, 2 May 2010 19:12:18 -0700 (PDT) From: Kaveh Mousavi Zamani Date: Mon, 3 May 2010 10:12:18 +0800 Message-ID: Subject: Prevent Domain Compare To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=0016e68ba2eb80a9310485a720ea X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.011 tagged_above=-5 required=5 tests=BAYES_20=-0.001, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201005/5 X-Sequence-Number: 34053 --0016e68ba2eb80a9310485a720ea Content-Type: text/plain; charset=ISO-8859-1 Hi, Is there a way that when I have to fields like F1 Domain1_Type F2 Domain2_Type I prevent comparison between this two fields. I mean I make them somehow in-compatible?! They are eventually TEXT but I want to prevent it from SQL level. Best Regards, Kaveh -- The GNU Operating System Free as in Freedom http://www.gnu.org --0016e68ba2eb80a9310485a720ea Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,

Is there a way that when I have to fields like
F1 Domain1_Ty= pe
F2 Domain2_Type

I prevent comparison between this two fields. = I mean I make them somehow in-compatible?!

They are eventually TEXT = but I want to prevent it from SQL level.

Best Regards,
Kaveh

--
The GNU Operating System
Free a= s in Freedom
http://www.gnu.org
--0016e68ba2eb80a9310485a720ea--