Pavel Stehule pavel.steh...@gmail.com writes:
When I worked on parametrised DO statement, I had to solve following issue:
DO currently is a utility command, not a query. Do you mean to change
that?
Also, did you think about a lambda construct, which is basically
allowing functions to be defined
2012/7/10 Dimitri Fontaine dimi...@2ndquadrant.fr:
Pavel Stehule pavel.steh...@gmail.com writes:
When I worked on parametrised DO statement, I had to solve following issue:
DO currently is a utility command, not a query. Do you mean to change
that?
Also, did you think about a lambda
Dimitri Fontaine dimi...@2ndquadrant.fr writes:
We could imagine several syntax to show up the idea, common keywords
here include LAMBDA, FLET or LABELS, but I think that expanding WITH
would be preferable for us.
WITH FUNCTION foo(param list) returns rettype language foo AS (
2012/7/10 Tom Lane t...@sss.pgh.pa.us:
Dimitri Fontaine dimi...@2ndquadrant.fr writes:
We could imagine several syntax to show up the idea, common keywords
here include LAMBDA, FLET or LABELS, but I think that expanding WITH
would be preferable for us.
WITH FUNCTION foo(param list) returns
Pavel Stehule pavel.steh...@gmail.com writes:
WITH FUNCTION foo(param list) returns rettype language foo AS (
definition here
)
query using foo() here;
I like this idea. This gets rid of both the how to pass parameters
and the how to return results issues that exist with DO, as
2012/7/10 Dimitri Fontaine dimi...@2ndquadrant.fr:
Pavel Stehule pavel.steh...@gmail.com writes:
WITH FUNCTION foo(param list) returns rettype language foo AS (
definition here
)
query using foo() here;
I like this idea. This gets rid of both the how to pass parameters
and the
Pavel Stehule pavel.steh...@gmail.com writes:
2012/7/10 Dimitri Fontaine dimi...@2ndquadrant.fr:
I'm not sure I can understand the difference between that and the use
case for which you want to implement DO blocks with parameters.
this is similar to temporary functions - you need some
Excerpts from Tom Lane's message of mar jul 10 10:56:50 -0400 2012:
Pavel Stehule pavel.steh...@gmail.com writes:
2012/7/10 Dimitri Fontaine dimi...@2ndquadrant.fr:
I'm not sure I can understand the difference between that and the use
case for which you want to implement DO blocks with
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from Tom Lane's message of mar jul 10 10:56:50 -0400 2012:
What's to solve? Presumably the WITH function name would take
precedence over anything in the catalogs, the same as WITH query names
take precedence over actual tables.
Hm,
Hello
When I worked on parametrised DO statement, I had to solve following issue:
Syntax is:
DO (param list) $$ ... $$ LANGUAGE ... USING expr_list
What is correct way for evaluation of expr_list with specified target types?
I used two techniques:
1) evaluation expressions -
Pavel Stehule pavel.steh...@gmail.com writes:
When I worked on parametrised DO statement, I had to solve following issue:
Syntax is:
DO (param list) $$ ... $$ LANGUAGE ... USING expr_list
What is correct way for evaluation of expr_list with specified target types?
I'd argue that that's a
2012/7/8 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
When I worked on parametrised DO statement, I had to solve following issue:
Syntax is:
DO (param list) $$ ... $$ LANGUAGE ... USING expr_list
What is correct way for evaluation of expr_list with specified
12 matches
Mail list logo