Re: [GENERAL] Table with differerent Data Types

[xaviergxf]

hi, i haven´t found the explication about my problem...


On 24 abr, 03:04, [EMAIL PROTECTED] (Klint Gore) wrote:
 xaviergxf wrote:
  Hi,

     I´m trying to do the follow: create a table like:
  create table t(
    cod serial,
    data_type char(10),
    value ???
  );

  I would like to do the follow the table would tell me what data type
  its the value. For instance:

  insert into t values(1, 'Integer', 12);
  insert into t values(2, 'String', 'test');
  insert into t values(3, 'Float', 1.23);

  How can i do that? Its that possible? How Can i solve this problem?

 seehttp://www.varlena.com/varlena/GeneralBits/110.php

 klint.

 --
 Klint Gore
 Database Manager
 Sheep CRC
 A.G.B.U.
 University of New England
 Armidale NSW 2350

 Ph: 02 6773 3789  
 Fax: 02 6773 3266
 EMail: [EMAIL PROTECTED]

 --
 Sent via pgsql-general mailing list ([EMAIL PROTECTED])
 To make changes to your 
 subscription:http://www.postgresql.org/mailpref/pgsql-general- Ocultar texto 
 entre aspas -

 - Mostrar texto entre aspas -


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Table with differerent Data Types

[Klint Gore]

xaviergxf wrote:

Hi,


   I´m trying to do the follow: create a table like:
create table t(
  cod serial,
  data_type char(10),
  value ???
);

I would like to do the follow the table would tell me what data type
its the value. For instance:

insert into t values(1, 'Integer', 12);
insert into t values(2, 'String', 'test');
insert into t values(3, 'Float', 1.23);

How can i do that? Its that possible? How Can i solve this problem?
  

see http://www.varlena.com/varlena/GeneralBits/110.php

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789  
Fax: 02 6773 3266

EMail: [EMAIL PROTECTED]


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Table with differerent Data Types

[xaviergxf]

Hi,


   I´m trying to do the follow: create a table like:
create table t(
  cod serial,
  data_type char(10),
  value ???
);

I would like to do the follow the table would tell me what data type
its the value. For instance:

insert into t values(1, 'Integer', 12);
insert into t values(2, 'String', 'test');
insert into t values(3, 'Float', 1.23);

How can i do that? Its that possible? How Can i solve this problem?


Thanks a lot

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general