Postgres Pro
Downloads
Home   >   mailing lists

Thread: Table with differerent Data Types

Table with differerent Data Types

From
xaviergxf
Date:
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

Re: Table with differerent Data Types

From
Klint Gore
Date:
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: kgore4@une.edu.au

Re: Table with differerent Data Types

From
xaviergxf
Date:
hi, i haven´t found the explication about my problem...


On 24 abr, 03:04, kgo...@une.edu.au (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: kgo...@une.edu.au
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general- Ocultar texto entre aspas -
>
> - Mostrar texto entre aspas -