Re: dblink: add polymorphic functions. - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: dblink: add polymorphic functions.
Date
Msg-id CADkLM=fWLeAUntWKUDfdj-O4OEkyeDUfEYjEc1wTzv22ps9g=A@mail.gmail.com
Whole thread Raw
In response to Re: dblink: add polymorphic functions.  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers


Ok, gotcha. So Tom's nearby comment about allowing the
"p_rowtype%TYPE" syntax to be used in the CAST is spot on (as usual).
In other words, to get a complete solution for you we would need to
make both things work, so you could do this inside plpgsql:

  select * from cast(dblink(connstr, sql) as p_rowtype%TYPE);

where potentially connstr, sql, p_rowtype are all passed to plpgsql as
arguments. Correct?


Correct.



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: dblink: add polymorphic functions.
Next
From: Piotr Stefaniak
Date:
Subject: Division by zero in planner.c:grouping_planner()