Convert simple postgreSQL function to Mysql

Question

I was wondering if I could get some help. I have the following function in Postgresql which is designed to give me a "solrid" value without having to store it each time in the database, and basically works by putting an "A" at the start of the value.

-- Setup Solrid Function
CREATE OR REPLACE FUNCTION solrid(IN local_id INTEGER, OUT result TEXT) AS $$
DECLARE
    database_id TEXT := 'A';
BEGIN
    result := database_id || local_id::TEXT;
END;
 $$ LANGUAGE PLPGSQL;

I now have to move my database to MySql and I was wondering if anyone could tell me how I can convert this function to work with MySQL.

Just FYI, that doesn't need to be written in PL/PgSQL, the simple SQL function would be CREATE OR REPLACE FUNCTION solrid(integer) RETURNS text AS $$ SELECT 'A'||$1; $$ LANGUAGE SQL . This would be a heck of a lot faster and could often be inlined away. — Craig Ringer
– Craig Ringer, Commented Mar 7, 2013 at 11:18
It is a way of getting my job table "id" into a solr_id without having to store the solr_id. The job "id" might be 123 and the solr_id would be A123. — Jimmy
– Jimmy, Commented Mar 7, 2013 at 11:22
@CraigRinger Also, can you explain where it references the initial ID? I,e where is the table jobs "id"? — Jimmy
– Jimmy, Commented Mar 7, 2013 at 14:15

Rostyslav · Accepted Answer · 2013-03-07 11:40:44Z

1

Here is the same function in MySQL:

DELIMITER //

DROP FUNCTION IF EXISTS solrid //

CREATE FUNCTION solrid(local_id INTEGER) RETURNS TEXT
BEGIN
  DECLARE database_id TEXT;
  SET database_id = 'A';
  RETURN CONCAT(database_id, CAST(local_id AS CHAR));
END //

DELIMITER ;

answered Mar 7, 2013 at 11:40

Rostyslav

4283 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert simple postgreSQL function to Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related