Re: Converting to identity columns with domains on PK columns - Mailing list pgsql-general

From PegoraroF10
Subject Re: Converting to identity columns with domains on PK columns
Date
Msg-id 1562356860333-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Converting to identity columns with domains on PK columns  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Converting to identity columns with domains on PK columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Converting to identity columns with domains on PK columns  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Adrian, on Firebird if you create a table or procedure with fields or params
declared with domains, they can be used with those domains or with their
base type. On Postgres I32 is not equal to integer.

create procedure myproc(id i32) returns(x i32) as ...

select * from myproc(cast(5 as integer)) -- works on firebird. On Postgres
it doesn´t because that procedure or function expects for a I32 and not a
integer.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



pgsql-general by date:

Previous
From: Felipe de Jesús Molina Bravo
Date:
Subject: xpath differences between postgres 11.4 and 10.3
Next
From: Tom Lane
Date:
Subject: Re: Converting to identity columns with domains on PK columns