Sophie

Sophie

distrib > Mageia > 5 > x86_64 > by-pkgid > b260f75b6aaa724512b6186bbc82ff5c > files > 106

firebird-2.5.3.26778-4.mga5.x86_64.rpm

-------------------
Column type in PSQL
-------------------

Function:
    Allow usage of table or view column type in PSQL.

Author:
    Adriano dos Santos Fernandes <adrianosf@uol.com.br>

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