how to use schema with data type

From: John Fabiani <johnf(at)jfcomputer(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: how to use schema with data type
Date: 2012-06-13 00:46:53
Message-ID: 4FD7E2FD.9020207@jfcomputer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2012-06-13 02:37:49 Re: Partitioned Tables
Previous Message Wayne Cuddy 2012-06-13 00:05:45 Partitioned Tables