Re: Information schema question.

2008-03-19 Thread Sebastian Mendel 

Carlos Savoretti schrieb:

Hi all!

Well, question is how could I to retrieve information about
types supported.



IMHO, no

--
Sebastian

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Information schema question.

2008-03-19 Thread Rob Wultsch 
On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti
[EMAIL PROTECTED] wrote:
 Hi all!

  Well, question is how could I to retrieve information about
  types supported . In PostgreSQL the query would be:

  --
  SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid)
  FROM pg_type, pg_user
  WHERE typowner=usesysid AND typrelid = 0 AND typname !~ '^_'
  --

  Is there some way to obtain equivalent columns from INFORMATION_SCHEMA,
  as similar as possible ?
I do not think you can use the information schema to get this
information. However you can use help:

For server side help, type 'help contents'

mysql help DATA TYPES
You asked for help about help category: Data Types
For more information, type 'help item', where item is one of the following
topics:
   AUTO_INCREMENT
   BIGINT
   BINARY
   BIT
   BLOB
   BLOB DATA TYPE
   BOOLEAN
   CHAR
   CHAR BYTE
   DATE
   DATETIME
   DEC
   DECIMAL
   DOUBLE
   DOUBLE PRECISION
   ENUM
   FLOAT
   INT
   INTEGER
   LONGBLOB
   LONGTEXT
   MEDIUMBLOB
   MEDIUMINT
   MEDIUMTEXT
   SET DATA TYPE
   SMALLINT
   TEXT
   TIME
   TIMESTAMP
   TINYBLOB
   TINYINT
   TINYTEXT
   VARBINARY
   VARCHAR
   YEAR DATA TYPE

mysql help INT
Name: 'INT'
Description:
INT[(M)] [UNSIGNED] [ZEROFILL]

A normal-size integer. The signed range is -2147483648 to 2147483647.
The unsigned range is 0 to 4294967295.

URL: http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

-- 
Rob Wultsch

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Information schema question.

2008-03-18 Thread Carlos Savoretti 
Hi all!

Well, question is how could I to retrieve information about
types supported . In PostgreSQL the query would be:

--
SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid)
FROM pg_type, pg_user 
WHERE typowner=usesysid AND typrelid = 0 AND typname !~ '^_' 
--

Is there some way to obtain equivalent columns from INFORMATION_SCHEMA,
as similar as possible ?

Thanks in advance...

Carlos Savoretti.





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]