Run a postgresql function in Play! framework

Question

I want to create some Postgresql (9.3) functions like "upsert" for my application in Play! Scala 2.2. I have tested one of them in the console and it worked great, but when I add it to evolutions (1.sql file) I get an error :

unterminated dollar-quoted string at or near "$$.

(I can show you the function but I'm not sure that it will help since I'm sure that the function is valid.)

I tried to end my function by ";;" instead of ";" as mentioned here : a similar SO question but without result.

So I'm asking you, what is the standard way to run SQL functions in Play ?

By the way, I will have several postgresql functions and it won't be clear if I let all of them in the 1.sql file, so is there a way to write them in other files ?

I'm using Anorm but (I think that) it doesn't change anything since the function is executed in my evolution file and the error comes at the compilation time. — Simon
– Simon, Commented Mar 19, 2015 at 11:55

Community · Accepted Answer · 2017-05-23 12:08:44Z

1

I finally found a solution: as mentioned in this thread, you need to replace ";" by ";;" but not only at the end of the function but for every ";".

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Mar 19, 2015 at 13:49

Simon

6,5308 gold badges55 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

Run a postgresql function in Play! framework

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related