postgreSQL 8beta

--Apple-Mail-3--357258358
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
format=flowed

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


--Apple-Mail-3--357258358
Content-Transfer-Encoding: 7bit
Content-Type: text/enriched;
charset=US-ASCII

Hi,

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



Verdana 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




--Apple-Mail-3--357258358--

Re: postgreSQL 8beta

> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: postgreSQL 8beta

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

Ted

--- beyaNet 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



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly