From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: postgreSQL 8beta
Date: Sat, 13 Nov 2004 23:48:32 +0100
Message-ID: <20041113234832.F568@hermes.hilbert.loc> (raw)
In-Reply-To: <38447DBC-3581-11D9-B19E-0003938366A4@jibeya.com>
References: <38447DBC-3581-11D9-B19E-0003938366A4@jibeya.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Karsten.Hilbert@gmx.net
Subject: Re: postgreSQL 8beta
In-Reply-To: <20041113234832.F568@hermes.hilbert.loc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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