Re: (SETOF) RECORD AS complex_type - Mailing list pgsql-hackers

From Tom Lane
Subject Re: (SETOF) RECORD AS complex_type
Date
Msg-id 25473.1167261737@sss.pgh.pa.us
Whole thread Raw
In response to (SETOF) RECORD AS complex_type  (David Fetter <david@fetter.org>)
Responses Re: (SETOF) RECORD AS complex_type
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> What would be involved in fixing the casting operation so that the
> following would work?

> CREATE TYPE foo AS (
>     a INT4,
>     b INT8,
>     c POINT,
>     d TEXT
> );

> CREATE FUNCTION bar(output_type TEXT)
> RETURNS SETOF RECORD
> ...

> SELECT * FROM bar('foo') AS foo;

The problem with that is that "AS foo" already has a meaning, and it's
not this one.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] [BUGS] BUG #2846: inconsistent and confusing handling of underflows,
Next
From: David Fetter
Date:
Subject: Re: (SETOF) RECORD AS complex_type