Re: Converting to identity columns with domains on PK columns

From: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Converting to identity columns with domains on PK columns
Date: 2019-07-05 20:01:00
Message-ID: 1562356860333-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-07-05 20:16:20 Re: Converting to identity columns with domains on PK columns
Previous Message Felipe de Jesús Molina Bravo 2019-07-05 19:22:55 xpath differences between postgres 11.4 and 10.3