Re: Check type compatibility

From: Nilesh Govindarajan <lists(at)itech7(dot)com>
To: Gianvito Pio <pio(dot)gianvito(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Check type compatibility
Date: 2010-03-06 11:22:12
Message-ID: c31975b61003060322k347683f9l4c4f1d40be7b49ea@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, Mar 6, 2010 at 4:34 PM, Gianvito Pio <pio(dot)gianvito(at)gmail(dot)com> wrote:

> 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
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

Explain in more detail.

--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Little, Douglas 2010-03-06 13:21:57 Re: Check type compatibility
Previous Message Gianvito Pio 2010-03-06 11:04:08 Check type compatibility