Re: [SQL] Check type compatibility

2010-03-06 Thread Little, Douglas
rch 06, 2010 5:04 AM To: pgsql-sql@postgresql.org Subject: [SQL] Check type compatibility 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

Re: [SQL] Check type compatibility

2010-03-06 Thread Nilesh Govindarajan
On Sat, Mar 6, 2010 at 4:34 PM, Gianvito Pio 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 >... > EL

[SQL] Check type compatibility

2010-03-06 Thread Gianvito Pio
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 l