Re: using a generated series in function

From: Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: John Fabiani <johnf(at)jfcomputer(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: using a generated series in function
Date: 2011-12-17 21:49:58
Message-ID: CAKwGa_965ysHev4vGNErN8U9GGqEJfed0nAG_Rp9KMfdzuWJZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

From is not required if you use literals or function results (with literal
> input parameters).

If you came from Oracle you could simply think that the "FROM DUAL" bit can
be omitted in Postgresql. There may be small differences, but that is the
basic idea.

Bèrto

--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stefan Weiss 2011-12-17 22:21:30 Re: Column "..." does not exist (view + union)
Previous Message Bèrto ëd Sèra 2011-12-17 21:36:00 Re: Column "..." does not exist (view + union)