From: Keith Worthington <keithw@narrowpathinc.com>
To: Joel Fradkin <jfradkin@wazagua.com>
To: pgsql-sql@postgresql.org
Subject: Re: Conversion ideas (Views/procedures)
Date: Wed, 19 Jan 2005 12:32:37 -0500
Message-ID: <20050119173237.M33569@narrowpathinc.com> (raw)
In-Reply-To: <000001c4fe3a$c49fecf0$797ba8c0@jfradkin>
References: <000001c4fe3a$c49fecf0$797ba8c0@jfradkin>
> I am new to Postgres and am converting our MSSQL database to Postgres.
>
> I just did my first function.
> My question is does it make sense to create functions for some of
> the common functionality available to the MSSQL world (left, isnull,
> etc) so I do not need visit every view, and stored procedure to
> remove them? If it does is there a body of work anywhere? If not
> what is the best approach just remove all non existent (re-engineer)
> functions from my views and procedures. I understand some of the
> items are available, but a bit different either the name of the
> function or its use. I did see a how to that alerted me to the
> datefiff being date_diff and to watch out for the yy needing to be
> 'year' etc. he mentioned to use coalesce() instead of isnull also.
> Any other common ones I should be aware of?
>
> Joel Fradkin
>
I like the idea myself of a 'library' that when placed first in the 'search
path' would allow an application designed for a MSSQL database to operate.
Obviously a similar library for Oracle, MySQL and others would also be
benefical. They could have the affect of increasing PostgreSQL's use by
reducing the immediate porting requirements. I do not know if this is
possible but it would be cool stuff.
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
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: keithw@narrowpathinc.com, jfradkin@wazagua.com
Subject: Re: Conversion ideas (Views/procedures)
In-Reply-To: <20050119173237.M33569@narrowpathinc.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