Re: Review: query result history in psql

Поиск
Список
Период
Сортировка
От ian link
Тема Re: Review: query result history in psql
Дата
Msg-id CAOOwM5+37pRWXr2j_sAq7HLhJ20T5805O_9+0z5t8prp0m2KgA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Review: query result history in psql  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
<div dir="ltr"><blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span
style="font-family:arial,sans-serif;font-size:13px">I'mkinda not all that convinced that this feature does anything<br
/></span><spanstyle="font-family:arial,sans-serif;font-size:13px">that's actually useful.  If you want to save your
queryresults, you<br /></span><span style="font-family:arial,sans-serif;font-size:13px">can just stick "CREATE TEMP
TABLEans AS" in front of your query.<br /></span><span style="font-family:arial,sans-serif;font-size:13px">What does
thatnot give you that this gives you?</span></blockquote><div style="style">Convenience. It auto-increments with each
newquery, giving you a different temporary table for each query. Seems pretty helpful to me.</div></div><div
class="gmail_extra"><br/><br /><div class="gmail_quote">On Tue, Jul 2, 2013 at 6:16 PM, Robert Haas <span
dir="ltr"><<ahref="mailto:robertmhaas@gmail.com" target="_blank">robertmhaas@gmail.com</a>></span> wrote:<br
/><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div
class="im">OnTue, Jul 2, 2013 at 8:16 PM, ian link <<a href="mailto:ian@ilink.io">ian@ilink.io</a>> wrote:<br />
>We covered that earlier in the email thread, but it's the current name for<br /> > the query history. I think we
aregoing to change it to something a little<br /> > more descriptive. I was thinking "qh" for short or
"query-history".<br/> ><br /> >> I'm not sure if I'll be able to implement this feature any time soon,<br />
>>as I'm very busy at the moment and going for a business trip in few<br /> >> days.<br /> ><br /> >
Ican try implementing the feature, I might have some time.<br /><br /></div>I'm kinda not all that convinced that this
featuredoes anything<br /> that's actually useful.  If you want to save your query results, you<br /> can just stick
"CREATETEMP TABLE ans AS" in front of your query.<br /> What does that not give you that this gives you?<br /><span
class="HOEnZb"><fontcolor="#888888"><br /> --<br /> Robert Haas<br /> EnterpriseDB: <a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a><br /> The Enterprise PostgreSQL
Company<br/></font></span></blockquote></div><br /></div> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Review: query result history in psql
Следующее
От: "Etsuro Fujita"
Дата:
Сообщение: Re: Patch for removng unused targets