Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: Postgresql and Oracle data Type

    I would like to know, if it's correct?
    else, could you correct it?

    ANSI Data type |ORACLE |Postgresql
    ====================================
    integer |NUMBER(10,0) |integer
    char(n) |CHAR(n) |character(n)
    varchar(n) |VARCHAR2(n) |character varying(n)
    varchar(n) |VARCHAR(n) |character varying(n)
    float |FLOAT |double precision
    boolean |NUMBER(1,0) |???

  2. #2
    Join Date
    Aug 2004
    Posts
    10

    Cool

    Quote Originally Posted by laurent.marquez
    I would like to know, if it's correct?
    else, could you correct it?

    ANSI Data type |ORACLE |Postgresql
    ====================================
    integer |NUMBER(10,0) |integer
    char(n) |CHAR(n) |character(n)
    varchar(n) |VARCHAR2(n) |character varying(n)
    varchar(n) |VARCHAR(n) |character varying(n)
    float |FLOAT |double precision
    boolean |NUMBER(1,0) |???
    Looks, from what I can see in PG 8, that the boolean is of type char(1). PG puts in a "1" (one), a "T", or a "t" for True, zero/F/f for False, or null.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •