2014-04-02 17:19 GMT+02:00 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
I was informed about impossibility to use a polymorphic functions
together
with domain types
see
create domain xx as numeric(15);
create or replace function g(anyelement,
Hello
I was informed about impossibility to use a polymorphic functions together
with domain types
see
create domain xx as numeric(15);
create or replace function g(anyelement, anyelement)
returns anyelement as
$$ select $1 + $2 $$
language sql immutable;
postgres=# select g(1::xx, 2::xx);
Pavel Stehule pavel.steh...@gmail.com writes:
I was informed about impossibility to use a polymorphic functions together
with domain types
see
create domain xx as numeric(15);
create or replace function g(anyelement, anyelement)
returns anyelement as
$$ select $1 + $2 $$
language sql
2014-04-02 17:19 GMT+02:00 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
I was informed about impossibility to use a polymorphic functions
together
with domain types
see
create domain xx as numeric(15);
create or replace function g(anyelement,
Tom Lane-2 wrote
Pavel Stehule lt;
pavel.stehule@
gt; writes:
I was informed about impossibility to use a polymorphic functions
together
with domain types
see
create domain xx as numeric(15);
create or replace function g(anyelement, anyelement)
returns anyelement as
$$ select
David Johnston pol...@yahoo.com writes:
Does something like:
SELECT ($1 + $2)::$1%TYPE
exist where you can explicitly cast to the type of the input argument?
I don't think SQL-language functions have such a notation, but it's
possible in plpgsql, if memory serves.
2014-04-02 18:27 GMT+02:00 Tom Lane t...@sss.pgh.pa.us:
David Johnston pol...@yahoo.com writes:
Does something like:
SELECT ($1 + $2)::$1%TYPE
exist where you can explicitly cast to the type of the input argument?
I don't think SQL-language functions have such a notation, but it's
On 2014-04-02 12:27:30 -0400, Tom Lane wrote:
David Johnston pol...@yahoo.com writes:
Does something like:
SELECT ($1 + $2)::$1%TYPE
exist where you can explicitly cast to the type of the input argument?
I don't think SQL-language functions have such a notation, but it's
possible in
Tom Lane-2 wrote
David Johnston lt;
polobo@
gt; writes:
Does something like:
SELECT ($1 + $2)::$1%TYPE
exist where you can explicitly cast to the type of the input argument?
I don't think SQL-language functions have such a notation, but it's
possible in plpgsql, if memory serves.
2014-04-02 18:34 GMT+02:00 David Johnston pol...@yahoo.com:
Tom Lane-2 wrote
David Johnston
polobo@
writes:
Does something like:
SELECT ($1 + $2)::$1%TYPE
exist where you can explicitly cast to the type of the input argument?
I don't think SQL-language functions have such a
10 matches
Mail list logo