Skip site navigation (1) Skip section navigation (2)

Re: Porting problem from Informix to Postgres...

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Porting problem from Informix to Postgres...
Date: 2004-09-22 11:48:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
O Marco Gaiarin έγραψε στις Sep 22, 2004 :

> On our organization we are porting an old, internally developed app,
> that use Informix (SE 7.XX, on a sun box) as database backend and Gupta
> Centura Team Developer 1.5.1 as development environment.
> Centura uses Informix via a native driver, for postgres we pass along
> odbc. Our postgres environment are a set of intel box, loaded with
> debian woody, so postgres 7.2.1.
> We have solved many problem, i've also make a little perl script that
> convert a informix's dbexport dump into a set of file suitable to
> import into postgres.
> Now we are moving the app... we was happy, because seems that the only
> modification needed was to alter some of the more complex query,
> because of the difference on informix and postgres sql dialects.
> But a big problem now arise: at the very beginning of this app, there
> was a bug in handling of date in centura, so the guys circumvent this
> converting all date in strings, and handle ``manually''.
> Not sufficient, they don't do this with a wrapper function around date
> field, but with ``casting'' data in varchar in the selects (with select
> ... into ...) and only local computation.
> It's dumb, i know. ;(
> So now, on informix, a set of centura statement like:
> 	Call SqlPrepareAndExecute(hsql,'select dt_fatt from fatture into :una')
> 	Call SqlFetchNext(hsql,err)
> make on string/variable :una a date like:
> 	'01-08-2001'
> for january 8, 2001, but on postgres we got:
> 	'2001-01-08'

Just a dummy workaround (i am sure you'll find something better),

dynacom=# SET DateStyle TO German ;
dynacom=# SELECT replace(now()::date::text,'.','-');

> There's a way to alter globally the date format (apart PGDATESTYLE
> variable, just tried with no luck), or there's a way to setup query to have
> the correct date format?
> I've tried to use the mailing list search robots, but looking for
> informix on this list (and on -general) make nothing. ;(
> Many thanks.


In response to

pgsql-sql by date

Next:From: Marco GaiarinDate: 2004-09-22 12:17:58
Subject: Porting problem from Informix to Postgres...
Previous:From: S.SreejithDate: 2004-09-22 11:11:49
Subject: Doubt

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group