Thread: how to use schema with data type

how to use schema with data type

From
John Fabiani
Date:
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.

I'm using 8.4.x.

Johnf


Re: how to use schema with data type

From
Craig Ringer
Date:
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