you have to escape those out with %%.
On Jan 18, 2012, at 3:06 AM, lestat wrote:
> Hi!
>
>
> If I create DDL like this with %:
>
> event.listen(db.metadata, 'after_create', DDL(
>"""
>CREATE OR REPLACE FUNCTION test_func() RETURNS void AS $$
>DECLARE
>max_user_id INTEGER;
>
Hi!
If I create DDL like this with %:
event.listen(db.metadata, 'after_create', DDL(
"""
CREATE OR REPLACE FUNCTION test_func() RETURNS void AS $$
DECLARE
max_user_id INTEGER;
BEGIN
SELECT INTO max_user_id MAX("id") FROM "user";
RAISE INFO 'max_user_id: (%)', max_user