Re: Debugging question ...

From: Robert Bernabe <rbernabe(at)sandmansystems(dot)com>
To: Josh Tolley <eggyknap(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Debugging question ...
Date: 2007-11-09 06:32:32
Message-ID: 4733FF00.2060809@sandmansystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks for the advice...although there is no choice but to try to port
over since we have 3k MS Sql stored procs already in the production
system...1st step seems to be to evaluate the performance of PG vs MS
SQL in our systems and the only way to do that is to port the massive
stored procs into PG and time the performance...

Josh Tolley wrote:

>On Nov 7, 2007 8:56 PM, Robert Bernabe <rbernabe(at)sandmansystems(dot)com> wrote:
>
>
>>
>>
>
>I recommend starting with the documentation. It sounds like you'd like
>to do pl/pgsql stuff, so you might try this link:
>http://www.postgresql.org/docs/8.2/interactive/plpgsql.html. Take
>sample functions from there, and adapt them to do what you need. It's
>easier to take something that works and learn the postgresql idioms
>from that rather than to take something from MS SQL and try to replace
>MS SQL-isms with PostgreSQL-isms.
>
>- Josh/eggyknap
>
>
>
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kasia Tuszynska 2007-11-09 17:06:36 Autovacuum - what does it actually do?
Previous Message Josh Tolley 2007-11-09 05:50:49 Re: Debugging question ...