From Newsgroup: comp.databases.ingres

Hi folks

How were date columns displayed by the help table statement prior to Ingres 11?

In my Ingres installation data_alias is set to ingresdate.

For example, for the following table definition:

create table steves_tmp (
col1 date not null with default);

In Ingres 11, help table steves_tmp displays the type of col1 as ingresdate.

I am curious to know if this was the case prior to Ingres 11? Or did help table display the type simply as date?

Thanks
Steve
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Steve wrote:

How were date columns displayed by the help table statement prior to Ingres 11?

[snip]

I am curious to know if this was the case prior to Ingres 11? Or did help table display the type simply as date?

I've just refreshed my memory using a 10.1 installation. As I thought,
it shows the date as ingresdate.

Roy

--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Roy Hann wrote:

I've just refreshed my memory using a 10.1 installation. As I thought,
it shows the date as ingresdate.

Thanks Roy, makes sense. I presume it must have changed when Ansidate was first included in Ingres 9.1.

The question arose because a script I use to migrate database changes between environments started failing. The script wasn't recognising the data type Ingresdate.

Steve
--- Synchronet 3.21b-Linux NewsLink 1.2