Message-ID: <4FD7FD65.70909@ringerc.id.au>
Date: Wed, 13 Jun 2012 10:39:33 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: johnf@jfcomputer.com
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: how to use schema with data type
References: <4FD7E2FD.9020207@jfcomputer.com>
In-Reply-To: <4FD7E2FD.9020207@jfcomputer.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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