'VARCHAR2'=>'varchar',

'NVARCHAR2'=>'varchar',

'DATE'=>'datetime',

'DATE'=>'timestamp',

'LONG'=>'text',# Character data of variable length

CREATE TABLE mdt (

idint4,

idesctext,

moddatedatetime DEFAULTdatetime(CURRENT_TIMESTAMP) NOT NULL

moddatetimestamp DEFAULT CURRENT_TIMESTAMP NOT NULL

);

CREATE TRIGGER mdt_moddatetime

if ((strcmp(type,"text")&&strcmp(type,"varchar")&&

strcmp(type,"char")&&strcmp(type,"bpchar")&&

strcmp(type,"date")&&strcmp(type,"datetime"))==0)

strcmp(type,"date")&&strcmp(type,"timestamp"))==0)

is_char_type=1;

elog(DEBUG3,"Check_foreign_key Debug value %s type %s %d",

insert into tttest(price_id, price_val,price_off) values (3, 3, 'infinity');

insert into tttest(price_id, price_val,price_off) values (3, 3,

datetime_abstime(datetime_mi_span('now','100')));

abstime('now'::timestamp -'100 days'::interval));

insert into tttest(price_id, price_val,price_on) values (3, 3, 'infinity');

select * from tttest;

--- apachelog.sql : ---

drop table access;

CREATE TABLE access (host char(200), ident char(200), authuser char(200), accdatedatetime, request char(500), ttime int2, status int2, bytes int4) archive = none;

CREATE TABLE access (host char(200), ident char(200), authuser char(200), accdatetimestamp, request char(500), ttime int2, status int2, bytes int4) archive = none;

grant all on access to nobody;

--- httpconf.txt: ---

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.91 2002/04/25 20:14:43 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.92 2002/05/03 04:11:07 tgl Exp $

-->

<chapter id="datatype">

outside that range are in <acronym>UTC</acronym>.

</para>

<para>

To ensure an upgrade path from versions of

<productname>PostgreSQL</productname> earlier than 7.0,

we recognize <type>datetime</type>

(equivalent to <type>timestamp</type>) and

<type>timespan</type> (equivalent to <type>interval</type>).

These types are

now restricted to having an

implicit translation to <type>timestamp</type> and

<type>interval</type>, and

support for these will be removed in the next release of

<productname>PostgreSQL</productname> (likely named 7.3).

</para>

<para>

The types <type>abstime</type>

and <type>reltime</type> are lower precision types which are used internally.

You are discouraged from usingany ofthese types in new

You are discouraged from using these types in new

applications and are encouraged to move any old

ones over when appropriate. Any or all of these internal types

might disappear in a future release.

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.57 2002/04/09 03:08:25 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.58 2002/05/03 04:11:07 tgl Exp $

-->

<chapter id="plpgsql">

package would become something like this:

<programlisting>

CREATE FUNCTION acs__add_user(INTEGER,INTEGER,VARCHAR,DATETIME,INTEGER,INTEGER,...)

CREATE FUNCTION acs__add_user(INTEGER,INTEGER,VARCHAR,TIMESTAMP,INTEGER,INTEGER,...)

RETURNS INTEGER AS '

DECLARE

user_id ALIAS FOR $1;

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.133 2002/04/18 20:01:08 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.134 2002/05/03 04:11:07 tgl Exp $

-->

<appendix id="release">

worries about funny characters.

-->

<literallayout><![CDATA[

The last vestiges of support for type names datetime and timespan are gone; use timestamp and interval instead

Rule names are now per-relation, not global; DROP RULE and COMMENT ON RULE syntax changes accordingly

Readline and Zlib are now required by default and must be turned off explicitly if their use is not desired

Define a third class of function volatility to allow indexscans in more cases

DATETIME=pgdbType(

'abstime','reltime','tinterval','date','time','timespan','timestamp'

'abstime','reltime','tinterval','date','time','timespan','timestamp','timestamptz','interval'

)