Ingres SQL documentation

WilliamR · #1 (**permalink**) 11-02-04, 10:01

Can anyone recommend a site for Ingres SQL documentation?

Also, how do you tell what version of Ingres you have? We are running queries to extract data from an Ingres database over ODBC.

One particular query we are having trouble with is something like this (Oracle equivalent):

Code:

SELECT account_no
     , MIN(LEAST(date1, date2))    AS first_bill_date
     , MAX(GREATEST(date1, date2)) AS last_bill_date
FROM   bill_history
GROUP BY account_no;

Thanks in advance

weaselboy1976 · #2 (**permalink**) 11-02-04, 11:36

You can find the Ingres version with this query:

select dbmsinfo('_version');

Computer Associate's web site has documentation. www.ca.com

PaulMason · #3 (**permalink**) 11-04-04, 07:52

There's no LEAST or GREATEST function as such. However you can use a CASE statement

Code:

SELECT account_no
     CASE WHEN MIN(date1) < MIN(date2) THEN MIN(date1) ELSE MIN(date2) END 
            AS first_bill_date,
     CASE WHEN MAX(date1) > MAX(date2) THEN MAX(date1) ELSE MAX(date2) END 
            AS last_bill_date
FROM   bill_history
GROUP BY account_no;

Look here for doc ftp://ftp.ca.com/pub/ingres/docs/

WilliamR · #4 (**permalink**) 11-04-04, 13:58

Thanks guys.

The dbmsinfo tip revealed that we are connecting to an Ingres 2.0 database, and it seems CASE was not supported in that version.

However at least we now have an Ingres SQL manual and we know what we're dealing with, so we're in a much better position.

Internet Services

Web Development

Digital Marketing

Consumer Tech