Re: Err sum number with Date ?

From: "Chad R(dot) Larson" <clarson(at)eldocomp(dot)com>
To: <nickf(at)ontko(dot)com>, "Robson Martins" <robson-martins(at)bol(dot)com(dot)br>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Err sum number with Date ?
Date: 2002-06-14 17:26:35
Message-ID: 4.2.2.20020614102029.00a75d20@ecint.ecinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

At 12:59 PM 6/13/02 , Nick Fankhauser wrote:
>In this, and your last question, the problem is that you are using
>functions from Microsoft Access. You'll keep running into this until you
>learn about the equivalent functions in PostgreSQL.

Further, learning ANSI SQL and limiting your syntax to that defined there,
so that if (God forbid) you should need to replace your PostgreSQL with
something like Informix or Oracle you won't face the same problem all
over. In otherwords, don't use any database's extensions unless there is a
compelling reason to do so. Unfortunately, that means you have to be able
to identify what =is= an extension, something Microsoft tries very hard to
hide.

In fact, if you were truly compulsive about such things (and I am), you
would only access the database through ODBC. That would make changing
database engines practically painless.

Layer both your view of the system, and the software that implements it.

-crl
--
Chad R. Larson (CRL22) chad(at)eldocomp(dot)com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Yiu-Man Yee 2002-06-14 19:04:38 postgresql 7.2.1 on Solaris 8 PAM authentication problem
Previous Message Robson Martins 2002-06-14 17:18:02 Help