PostgreSQL -- Function declaration missing cost specification.
5 views
Skip to first unread message
Faron Dutton
Apr 1, 2012, 10:04:08 AM4/1/12
to DB Solo
I have a function like this:
create function foo() as $$
...
$$
LANGUAGE sql STABLE
COST 100
ROWS 50000;
The generated function looks like this:
create function foo() as $$
...
$$
LANGUAGE 'sql' SECURITY INVOKER;
The cost specification is used by PostgreSQL when building the
execution plan.
create function foo() as $$
...
$$
LANGUAGE sql STABLE
COST 100
ROWS 50000;
The generated function looks like this:
create function foo() as $$
...
$$
LANGUAGE 'sql' SECURITY INVOKER;
The cost specification is used by PostgreSQL when building the
execution plan.
Marko Hantula
Apr 1, 2012, 11:07:08 PM4/1/12
to db-...@googlegroups.com
The cost specification should now be included. Please download the
latest from dbsolo.com/preview.
latest from dbsolo.com/preview.
Marko
> --
> You received this message because you are subscribed to the Google Groups "DB Solo" group.
> To post to this group, send email to db-...@googlegroups.com.
> To unsubscribe from this group, send email to db-solo+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/db-solo?hl=en.
>
Reply all
Reply to author
Forward
0 new messages