Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Array Char/VarC...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 1895 of 1984
Post > Topic >>

Array Char/VarChar Size

by danap@[EMAIL PROTECTED] (dmp) Feb 27, 2008 at 12:35 AM

Given a defined table as such:

CREATE TABLE array_types (

    data_type_id serial NOT NULL,
   
    decimal_array decimal(16,2)[] DEFAULT NULL,
    numeric_array numeric(10,2)[] DEFAULT NULL,
    varchar_array varchar(30)[] DEFAULT NULL,
    char_array char(30)[][] DEFAULT NULL,
    PRIMARY KEY  (data_type_id)
);

How do I obtain the precision, decimal places, or character
sizing information from the database. Notice these are array
types.

danap.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings




 6 Posts in Topic:
Array Char/VarChar Size
danap@[EMAIL PROTECTED]   2008-02-27 00:35:38 
Re: Array Char/VarChar Size
books@[EMAIL PROTECTED]   2008-02-29 11:59:17 
Re: Array Char/VarChar Size
danap@[EMAIL PROTECTED]   2008-02-29 10:32:15 
Re: Array Char/VarChar Size
books@[EMAIL PROTECTED]   2008-02-29 12:53:57 
Re: Array Char/VarChar Size
tgl@[EMAIL PROTECTED] (T  2008-02-29 13:44:27 
Re: Array Char/VarChar Size
danap@[EMAIL PROTECTED]   2008-03-01 15:10:41 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 9:26:06 CDT 2008.