Skip to content

Needs support for dollar-quoted string constants #2

@mertenvg

Description

@mertenvg

https://neon.tech/postgresql/postgresql-plpgsql/dollar-quoted-string-constants

Current solution is to use a single-quoted block; https://neon.tech/postgresql/postgresql-plpgsql/dollar-quoted-string-constants#using-dollar-quoted-string-constants-in-anonymous-blocks

do
'declare
   film_count integer;
begin
   select count(*) into film_count
   from film;

   raise notice ''The number of films: %'', film_count;
end;'
;

instead of

do
$$
declare
   film_count integer;
begin
   select count(*) into film_count
   from film;
   raise notice 'The number of films: %', film_count;
end;
$$;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions