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

Re: function in a view

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Keith Worthington <KeithW(at)NarrowPathInc(dot)com>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: function in a view
Date: 2005-04-29 14:49:08
Message-ID: 20050429144908.GA82580@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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/

In response to

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-04-30 04:56:57
Subject: PGAdmin3 and Permission Display
Previous:From: Keith WorthingtonDate: 2005-04-29 14:18:35
Subject: Re: function in a view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group