X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A545E3A4B96 for ; Sat, 13 Nov 2004 23:00:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99068-04 for ; Sat, 13 Nov 2004 23:00:11 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 80E1E3A4B76 for ; Sat, 13 Nov 2004 23:00:12 +0000 (GMT) Received: (qmail 7488 invoked by uid 65534); 13 Nov 2004 23:00:10 -0000 Received: from p5087FAA4.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc) (80.135.250.164) by mail.gmx.net (mp006) with SMTP; 14 Nov 2004 00:00:10 +0100 X-Authenticated: #1433807 Received: (from ncq@localhost) by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id iADMmWF08216 for pgsql-sql@postgresql.org; Sat, 13 Nov 2004 23:48:32 +0100 Date: Sat, 13 Nov 2004 23:48:32 +0100 From: Karsten Hilbert To: pgsql-sql@postgresql.org Subject: Re: postgreSQL 8beta Message-ID: <20041113234832.F568@hermes.hilbert.loc> References: <38447DBC-3581-11D9-B19E-0003938366A4@jibeya.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <38447DBC-3581-11D9-B19E-0003938366A4@jibeya.com> User-Agent: Mutt/1.3.22.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/131 X-Sequence-Number: 19450 > 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