Convert postgresql functions to mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
barb woolums
Forum Contributor
Posts: 134
Joined: Sun Feb 08, 2009 9:52 pm

Convert postgresql functions to mysql

Post by barb woolums »

I can't find any conversion tools that will convert postgresql functions/stored procedures to mysql.

Has anyone achieved this in some way?

My functions are very simple like below, but I have 100s of them so need a way to do in bulk, even if it's by copying and replacing text in the dump file

Code: Select all

CREATE OR REPLACE FUNCTION query_add_added_to_recipe(date, bigint)
  RETURNS void AS
'update recipe set added = $1 where id=$2'
  LANGUAGE sql VOLATILE
  COST 100;
Post Reply