Groups > comp.databases.postgresql > #597

Re: Returning a table in SQL

From	Robert Klemme <shortcutter@googlemail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: Returning a table in SQL
Date	2014-08-28 21:45 +0200
Message-ID	<c69f65FeaodU1@mid.individual.net> (permalink)
References	<ltignr$1hgl$1@adenine.netfront.net> <c644cpF2g32U1@mid.individual.net> <ltlfj0$1702$1@adenine.netfront.net> <c691fnFahj8U1@mid.individual.net>

Show all headers | View raw

On 28.08.2014 17:51, Harry Tuttle wrote:
> AP wrote on 27.08.2014 22:37:
>> Actually, I figured it out :
>>
>> with report as (select
>> some_report('Customer','2014-08-01','2014-08-08') cr)
>>   select
>>     (cr).field1,
>>     (cr).field2,
>>     (cr).field3
>>   from report;
>>
>> gives three separated columns.
>>
>> WITH clause is for clarity solely

No, in PostgreSQL it is an optimization fence that actually influences 
optimizer's behavior.  Apart from that I don't see the improvement in 
clarity caused by the additional layer.

> It's still "wrong".
>
> You should really put the function into the from clause.

s/should/must/

> select *
> from some_report('Customer','2014-08-01','2014-08-08')

Kind regards

	robert

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