Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Cast as compound type



Hello

maybe I don't understand well your idea. There exist simple syntax -
table function

http://archives.postgresql.org/pgsql-patches/2007-02/msg00341.php

and it is standard

regards
Pavel Stehule

On 30/03/2008, David Fetter <david(at)fetter(dot)org> wrote:
> Folks,
>
>  I'd like to take a whack at making set-returning functions returning
>  SETOF RECORD a little more fun to use.  Let's imagine that we have a
>  table foo and a function returning SETOF RECORD that can return foos.
>  The call might look something like:
>
>  SELECT a, b, c
>  FROM f(ROW OF foo)
>  WHERE ...;
>
>  This would make it much easier and less error-prone to use SETOF
>  RECORD.
>
>  Would others like to see such a feature?
>
>  If so, what pieces of the code would I be touching for the first
>  patch?
>
>  Cheers,
>  David.
>  --
>  David Fetter <david(at)fetter(dot)org> http://fetter.org/
>  Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
>  Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com
>
>  Remember to vote!
>  Consider donating to Postgres: http://www.postgresql.org/about/donate
>
>
>  --
>  Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
>  To make changes to your subscription:
>  http://www.postgresql.org/mailpref/pgsql-hackers
>



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group