From: Craig Ringer <ringerc@ringerc.id.au>
To: johnf@jfcomputer.com
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: how to use schema with data type
Date: Wed, 13 Jun 2012 10:39:33 +0800
Message-ID: <4FD7FD65.70909@ringerc.id.au> (raw)
In-Reply-To: <4FD7E2FD.9020207@jfcomputer.com>
References: <4FD7E2FD.9020207@jfcomputer.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ringerc@ringerc.id.au, johnf@jfcomputer.com
Subject: Re: how to use schema with data type
In-Reply-To: <4FD7FD65.70909@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox