Skip site navigation (1) Skip section navigation (2)

Re: postgreSQL 8beta

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: postgreSQL 8beta
Date: 2004-11-13 22:48:32
Message-ID: 20041113234832.F568@hermes.hilbert.loc (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-11-14 00:02:04
Subject: Re: select using regexp does not use indexscan
Previous:From: Stephan SzaboDate: 2004-11-13 21:39:27
Subject: Re: select using regexp does not use indexscan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group