Re: using a generated series in function - Mailing list pgsql-sql

From Bèrto ëd Sèra
Subject Re: using a generated series in function
Date
Msg-id CAKwGa_965ysHev4vGNErN8U9GGqEJfed0nAG_Rp9KMfdzuWJZQ@mail.gmail.com
Whole thread Raw
In response to Re: using a generated series in function  (David Johnston <polobo@yahoo.com>)
List 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.

pgsql-sql by date:

Previous
From: Bèrto ëd Sèra
Date:
Subject: Re: Column "..." does not exist (view + union)
Next
From: Stefan Weiss
Date:
Subject: Re: Column "..." does not exist (view + union)