From: "Joel Fradkin" <jfradkin@wazagua.com>
To: <pgsql-sql@postgresql.org>
Subject: Conversion ideas (Views/procedures)
Date: Wed, 19 Jan 2005 10:23:01 -0500
Message-ID: <000001c4fe3a$c49fecf0$797ba8c0@jfradkin>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
=A0
Wazagua, LLC
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.=A0 941-753-7111 ext 305
=A0
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
=A9 2004. WAZAGUA, LLC. All rights reserved. WAZAGUA, LLC
=A0This email message is for the use of the intended recipient(s) and =
may
contain confidential and privileged information.=A0 Any unauthorized =
review,
use, disclosure or distribution is prohibited.=A0 If you are not the =
intended
recipient, please contact the sender by reply email and delete and =
destroy
all copies of the original message, including attachments.
=A0

=A0