pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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> (raw)

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
 
Wazagua, LLC
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305
 
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
© 2004. WAZAGUA, LLC. All rights reserved. WAZAGUA, LLC
 This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.  Any unauthorized review,
use, disclosure or distribution is prohibited.  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.
 

 





view thread (3+ messages)  latest in thread

Message-ID: <000001c4fe3a$c49fecf0$797ba8c0@jfradkin>
Permalink:  ../000001c4fe3a$c49fecf0$797ba8c0@jfradkin/
Also on:    postgresql.org/message-id/000001c4fe3a$c49fecf0$797ba8c0@jfradkin

 · 

reply
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: jfradkin@wazagua.com
  Subject: Re: Conversion ideas (Views/procedures)
  In-Reply-To: <000001c4fe3a$c49fecf0$797ba8c0@jfradkin>

* 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