how to use schema with data type - Mailing list pgsql-sql

From John Fabiani
Subject how to use schema with data type
Date
Msg-id 4FD7E2FD.9020207@jfcomputer.com
Whole thread Raw
Responses Re: how to use schema with data type  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Wayne Cuddy
Date:
Subject: Partitioned Tables
Next
From: Craig Ringer
Date:
Subject: Re: Partitioned Tables