Not sure if this should be here or in the ODBC list (that one
looked more developer-ish, wheras this list seems more admin-ish.
anyway)
Testbedding an MS Access client to a PostgreSQL database, running
v 7.1.2 postgreSQL, Access 2000 on a Windows 2000 box. Got the driver,
version 7.1.0006.
> OK, so apparently the solution is to upgrade. My OS is currently RedHat
> 6.2. I'm a little leary of upgrading Linux at this point. Is there a
> way to run Postgresql 7 under RedHat 6.2 or do I have to upgrade?
Currently running PostgreSQL under RedHat 6.0 over here. Works like a
treat (tha
> Can anyone tell me how I might convert a null attribute value into a zero
> attribute value such that it can be multiplied in a query.
>
> In Oracle I could do:
>
> sal*12*NVL(COMM, 0) AS "Annual Income"
sal * 12 * CAST(COMM AS float8) AS "Annual Income"
Cheers
Jason
--
Indigo Industrial
