| Server IP : 172.67.156.203 / Your IP : 216.73.216.72 Web Server : Apache System : Linux gator4057.hostgator.com 5.14.0-687.17.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Jun 22 07:21:26 EDT 2026 x86_64 User : badawi ( 1130) PHP Version : 8.3.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/firebird/sql.extensions/ |
Upload File : |
-------------------
Column type in PSQL
-------------------
Function:
Allow usage of table or view column type in PSQL.
Author:
Adriano dos Santos Fernandes <[email protected]>
Syntax rules:
data_type ::=
<builtin_data_type>
| <domain_name>
| TYPE OF <domain_name>
| TYPE OF COLUMN <table or view>.<column>
Examples:
CREATE TABLE PERSON (ID INTEGER, NAME VARCHAR(40));
CREATE PROCEDURE SP_INS_PERSON
(ID TYPE OF COLUMN PERSON.ID, NAME TYPE OF COLUMN PERSON.NAME)
AS
DECLARE VARIABLE NEW_ID TYPE OF COLUMN PERSON.ID;
BEGIN
INSERT INTO PERSON (ID, NAME)
VALUES (:ID, :NAME)
RETURNING ID INTO :NEW_ID;
END
Notes:
1. TYPE OF COLUMN gets only the type of the column. It doesn't use constraints and default values.
See also:
README.domains_psql.txt