Why pgsql function is working on vers 8.0/windows and not on ver 7.3.2/rad hat?

From: "in-consulting(dot)net" <otto(at)in-consulting(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Why pgsql function is working on vers 8.0/windows and not on ver 7.3.2/rad hat?
Date: 2005-08-02 10:52:41
Message-ID: 000801c59750$50b34170$0301a8c0@inspirion
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hy,
I'm using a type defined by me: output_mt, on the function
CREATE OR REPLACE FUNCTION happy()
RETURNS SETOF output_mt AS....
and when I want to initialize from another function:
CREATE OR REPLACE FUNCTION msg()
RETURNS output_mt AS....
as: output_mt=msg();
it gaves me:
WARNING: plpgsql: ERROR during compile of happy near line xx
ERROR: parse error at or near "output_mt".
Why is this working on version 8.0 with windows and not on version 7.3.2 on linux, how can I solve this problem, do I need a cast or something ?
Thanks, Otto.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Springer 2005-08-02 11:10:49 Re: unicode error on win32 Was: Re: pgmonitor
Previous Message Havasvölgyi Ottó 2005-08-02 09:24:28 Re: feeding big script to psql