Groups > comp.databases.postgresql > #590

Re: Returning a table in SQL

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Harry Tuttle <SOZRBLNTLEEE@spammotel.com>
Newsgroups	comp.databases.postgresql
Subject	Re: Returning a table in SQL
Date	Tue, 26 Aug 2014 23:34:16 +0200
Lines	27
Message-ID	<c64cqoF4aveU1@mid.individual.net> (permalink)
References	<ltignr$1hgl$1@adenine.netfront.net> <c644cpF2g32U1@mid.individual.net> <c648uiF3fjsU1@mid.individual.net>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net U3mN86tB9s17/DCZZ96O/gWBabVsGyJVrhCBxh4X+stOa1frg=
Cancel-Lock	sha1:SxKtRyS8W78vMqkUnIsy8G2Z8qU=
User-Agent	Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To	<c648uiF3fjsU1@mid.individual.net>
Xref	csiph.com comp.databases.postgresql:590

Show key headers only | View raw

Robert Klemme wrote on 26.08.2014 22:28:
>> with report as (
>>      select *
>>      fromsome_report('Customer','2014-08-01','2014-08-08')
>> )
>> select *
>> from report
>
> I guess there is a space missing between "from" and "some_report".

Yes, of course. Copy & Paste error.

  
> It seems a simpler variant would be
>
> select *
> from some_report('Customer','2014-08-01','2014-08-08')
>
> Or does that not work?  (I do have no PG available for testing right now.)

Yes that would work just as well.
I assumed the example was a stripped down example of a large query that would benefit from the CTE.

Btw: if you don't have Postgres available you can use http://sqlfiddle.com

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Returning a table in SQL "AP" <unixpro-nospam@verizon.spam.net> - 2014-08-26 13:39 -0400
  Re: Returning a table in SQL Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2014-08-26 21:10 +0200
    Re: Returning a table in SQL Robert Klemme <shortcutter@googlemail.com> - 2014-08-26 22:28 +0200
      Re: Returning a table in SQL Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2014-08-26 23:34 +0200
        Re: Returning a table in SQL Robert Klemme <shortcutter@googlemail.com> - 2014-08-27 08:36 +0200
    Re: Returning a table in SQL "AP" <unixpronospam@verizon.net> - 2014-08-27 16:37 -0400
      Re: Returning a table in SQL Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2014-08-28 17:51 +0200
        Re: Returning a table in SQL Robert Klemme <shortcutter@googlemail.com> - 2014-08-28 21:45 +0200
        Re: Returning a table in SQL Jasen Betts <jasen@xnet.co.nz> - 2014-08-30 05:45 +0000
        Re: Returning a table in SQL "AP" <unixpronospam@verizon.net> - 2014-09-01 03:02 -0400
          Re: Returning a table in SQL Jasen Betts <jasen@xnet.co.nz> - 2014-09-01 10:56 +0000
            Re: Returning a table in SQL "AP" <unixpronospam@verizon.net> - 2014-09-04 02:57 -0400
              Re: Returning a table in SQL Jasen Betts <jasen@xnet.co.nz> - 2014-09-04 11:21 +0000
  Re: Returning a table in SQL Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2014-08-27 19:33 +0200

csiph-web