Re: Problem using set-returning functions

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: John DeSoi <desoi(at)pgedit(dot)com>
Cc: PostGIS Users Discussion <postgis-users(at)postgis(dot)refractions(dot)net>, PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem using set-returning functions
Date: 2006-03-27 14:00:35
Message-ID: 4427F003.2070705@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, John,

John DeSoi wrote:

> With SRFs, you need to specify what you want to select. In other words
> if you are calling generate_x(bar) you need "select * from
> generate_x(bar)" -- "select generate_x(bar)" will not work.

So, then, why does it work with generate_series() and dump()?

Confused,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-03-27 14:14:41 Re: pgsql aggregate: conditional max
Previous Message Jim C. Nasby 2006-03-27 13:56:29 Re: Find min and max values across two columns?