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@sandmansystems.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
>
>
>
>
>