pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

postgreSQL 8beta
3+ messages / 3 participants
[nested] [flat]

* postgreSQL 8beta
@ 2004-11-13 14:35 beyaNet <andrew@jibeya.com>
  2004-11-13 22:48 ` Re: postgreSQL 8beta Karsten Hilbert <Karsten.Hilbert@gmx.net>
  2004-11-14 13:50 ` Re: postgreSQL 8beta Theodore Petrosky <tedpet5@yahoo.com>
  0 siblings, 2 replies; 3+ messages in thread

From: beyaNet @ 2004-11-13 14:35 UTC (permalink / raw)
  To: pgsql-sql

Hi,
does postgresql have a datatype 'other' which in hsqldb is an Object? I 
am trying to convert the table below into postgreSQL 8:


  create table TIMERS (
  TIMERID varchar(50) not null,
  TARGETID varchar(50) not null,
  INITIALDATE timestamp not null,
  INTERVAL bigint,
  INSTANCEPK other,
  INFO other,
  constraint timers_pk primary key (TIMERID)


regards


Andrew

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgreSQL 8beta
  2004-11-13 14:35 postgreSQL 8beta beyaNet <andrew@jibeya.com>
@ 2004-11-13 22:48 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Karsten Hilbert @ 2004-11-13 22:48 UTC (permalink / raw)
  To: pgsql-sql

> does postgresql have a datatype 'other' which in hsqldb is an Object? I 
> am trying to convert the table below into postgreSQL 8: 
> 
>  create table TIMERS (  
>  TIMERID varchar(50) not null,  
>  TARGETID varchar(50) not null,  
>  INITIALDATE timestamp not null,  
>  INTERVAL bigint,  
>  INSTANCEPK other,  
>  INFO other,  
>  constraint timers_pk primary key (TIMERID)  

For INFO use either TEXT or BYTEA depending on what you want to
store. Regarding INSTANCEPK you should think again whether
OTHER is an appropriate datatype in the first place.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgreSQL 8beta
  2004-11-13 14:35 postgreSQL 8beta beyaNet <andrew@jibeya.com>
@ 2004-11-14 13:50 ` Theodore Petrosky <tedpet5@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Theodore Petrosky @ 2004-11-14 13:50 UTC (permalink / raw)
  To: beyaNet <andrew@jibeya.com>; pgsql-sql

Are you asking for a column of type  'unknown'? I
don't understand what this column would be able to do.

Ted

--- beyaNet <andrew@jibeya.com> wrote:

> Hi,
> does postgresql have a datatype 'other' which in
> hsqldb is an Object? I 
> am trying to convert the table below into postgreSQL
> 8:
> 
> 
>   create table TIMERS (
>   TIMERID varchar(50) not null,
>   TARGETID varchar(50) not null,
>   INITIALDATE timestamp not null,
>   INTERVAL bigint,
>   INSTANCEPK other,
>   INFO other,
>   constraint timers_pk primary key (TIMERID)
> 
> 
> regards
> 
> 
> Andrew
> 
> 


		
__________________________________ 
Do you Yahoo!? 
Check out the new Yahoo! Front Page. 
www.yahoo.com 
 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2004-11-14 13:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-13 14:35 postgreSQL 8beta beyaNet <andrew@jibeya.com>
2004-11-13 22:48 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
2004-11-14 13:50 ` Theodore Petrosky <tedpet5@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox