On 06/13/2012 08:46 AM, John Fabiani wrote:
I have tried to use a user defined data type I created within a schema.
But I could not figure it out.
CREATE OR REPLACE FUNCTION xchromasun._chromasun_totals(date)
RETURNS SETOF xchromasun.weekly_mpr AS
CREATE OR REPLACE FUNCTION xchromasun._chromasun_totals(date)
RETURNS SETOF "xchromasun.weekly_mpr" AS
I had to move the user defined data type to "public".
Could someone explain how I might get that done - that is use a schema
data type from a function.
What exactly couldn't you work out?
How was it going wrong, and when? What error messges did you get?
The first form looks reasonable to me, though I haven't tested. If you
need to quote the schema for caps reasons, you'd use:
"xchromasun"."weekly_mpr"
--
Craig Ringer
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
