From: Ulisses Ponticelli Giorgi <ulisses@compus.com.br>
To: pgsql-general@postgresql.org
Subject: PostgreSQL
Date: Thu, 26 Jun 2003 19:09:58 -0300
Message-ID: <00da01c33c2f$aecf0c40$1f00a8c0@compus.com.br> (raw)
Hi,
I´m SQL Server 2000 user and want to migrate to PostgreSQL,
mainly because is the most suitable database to my needs (it is very
robust) and because the price of SQL Server is scaring all my clients.
But I have a few problems with PostgreSQL that I'm stuck.
1) In my SQL Server database I have about 1,000 Stored
Procedures. In some cases, one SP calls another SP that calls another,
and so on. To do that, I use the EXEC command. I've read that PostgreSQL
only supports functions. Is there any kind of trick that I can use in
PostgreSQL to make easier the conversion of all my SPs? How could I do
this? I just can't get all my SPs and rewrite the code.
2) I use commands like CONVERT and CASE..WHEN..END in my
queries. This is another issue that I simply don't know what to do. Is
there any kind of library or product (if it exists, I but it) that can
solve this problem?
Please, sorry my lack of knowledge in PostgreSQL. I'm a beginner
in this database, but I believe that is the answer to my problems, manly
because the SQL Server is unbearable to maintain.
Best Regards,
Ulisses Ponticelli Giorgi
MSC Computer Science
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ulisses@compus.com.br
Subject: Re: PostgreSQL
In-Reply-To: <00da01c33c2f$aecf0c40$1f00a8c0@compus.com.br>
References: <00da01c33c2f$aecf0c40$1f00a8c0@compus.com.br>
* 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