Re: function in a view - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: function in a view
Date
Msg-id 20050429144908.GA82580@winnie.fuhr.org
Whole thread Raw
In response to Re: function in a view  (Keith Worthington <KeithW@NarrowPathInc.com>)
List pgsql-novice
On Fri, Apr 29, 2005 at 10:18:35AM -0400, Keith Worthington wrote:
>
> It seems like what your saying is that by enclosing the function in a
> set of parentheses I can access the return elements.

Right.  See "Field Selection" in the "SQL Syntax" chapter of the
documentation, and "Accessing Composite Types" in the "Data Types"
chapter.

http://www.postgresql.org/docs/8.0/interactive/sql-expressions.html#AEN1642
http://www.postgresql.org/docs/8.0/interactive/rowtypes.html#AEN5582

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: Keith Worthington
Date:
Subject: Re: function in a view
Next
From: "Marc Mamin"
Date:
Subject: connect from perl: error in Carp.pm