From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Marco Gaiarin <gaio@sv.lnf.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: Porting problem from Informix to Postgres...
Date: Wed, 22 Sep 2004 14:48:33 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0409221445030.5492-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <20040922121758.GG2319@sv.lnf.it>
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 ;
SET
dynacom=# SELECT replace(now()::date::text,'.','-');
replace
------------
22-09-2004
>
>
> 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.
>
>
--
-Achilleus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, gaio@sv.lnf.it
Subject: Re: Porting problem from Informix to Postgres...
In-Reply-To: <Pine.LNX.4.44.0409221445030.5492-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox