Re: [DOCS] [SQL] proposal for a CookBook in postgresql.org

2009-06-02 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian escribi?: > > Alvaro Herrera wrote: > > > > I don't know about Roberto Mello's site. Did we get a copyright > > > transfer or a license saying we could use the contents? > > > > Nope, but I assumed it was BSD-licensed. I see this Josh Berkus > > copyright:

Re: [DOCS] [SQL] proposal for a CookBook in postgresql.org

2009-06-02 Thread Alvaro Herrera
Bruce Momjian escribió: > Alvaro Herrera wrote: > > I don't know about Roberto Mello's site. Did we get a copyright > > transfer or a license saying we could use the contents? > > Nope, but I assumed it was BSD-licensed. I see this Josh Berkus > copyright: > > --Copyright Josh Berkus, j.

Re: [SQL] proposal for a CookBook in postgresql.org

2009-06-02 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian escribi?: > > > FYI, I have a copy of the old plpgsql cookbook at: > > > > http://www.brasileiro.net:8080/postgres/cookbook/ > > PostgreSQL CookBook Pages > > Roberto Mello > > > > http://techdocs.postgresql.org/guides/SetReturningFunctio

Re: [SQL] proposal for a CookBook in postgresql.org

2009-06-02 Thread Alvaro Herrera
Bruce Momjian escribió: > FYI, I have a copy of the old plpgsql cookbook at: > > http://www.brasileiro.net:8080/postgres/cookbook/ > PostgreSQL CookBook Pages > Roberto Mello > > http://techdocs.postgresql.org/guides/SetReturningFunctions > PostgreSQL 7.3 Set

Re: [SQL] proposal for a CookBook in postgresql.org

2009-06-02 Thread Bruce Momjian
Alvaro Herrera wrote: > Pavel Stehule escribi?: > > 2009/5/18 Alvaro Herrera : > > > Pavel Stehule escribi?: > > > > > >> others tricks http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks > > > > > > There's a lot of good stuff in there ... would you care about > > > copying/moving it to wiki.po

Re: [SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Alvaro Herrera
Pavel Stehule escribió: > 2009/5/18 Alvaro Herrera : > > Pavel Stehule escribió: > > > >> others tricks http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks > > > > There's a lot of good stuff in there ... would you care about > > copying/moving it to wiki.postgresql.org/wiki/Snippets ? > > This

Re: [SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Pavel Stehule
2009/5/18 Alvaro Herrera : > Pavel Stehule escribió: > >> others tricks http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks > > There's a lot of good stuff in there ... would you care about > copying/moving it to wiki.postgresql.org/wiki/Snippets ? > This contents is free - and if you would do

Re: [SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Alvaro Herrera
Pavel Stehule escribió: > others tricks http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks There's a lot of good stuff in there ... would you care about copying/moving it to wiki.postgresql.org/wiki/Snippets ? -- Alvaro Herrerahttp://www.CommandPrompt.com/ Po

Re: [SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Pavel Stehule
2009/5/18 Gerardo Herzig : > Dave Page wrote: >> On Mon, May 18, 2009 at 1:29 PM, Gerardo Herzig wrote: >> >>> I think this is a good time to propose some kind of CookBook, to >>> preserve this kind of answers. >> >> What, like this one? >> >> http://wiki.postgresql.org/wiki/Snippets >> >> :-) >>

Re: [SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Gerardo Herzig
Dave Page wrote: > On Mon, May 18, 2009 at 1:29 PM, Gerardo Herzig wrote: > >> I think this is a good time to propose some kind of CookBook, to >> preserve this kind of answers. > > What, like this one? > > http://wiki.postgresql.org/wiki/Snippets > > :-) > Oops. Yeah, kind of :) Did not see

Re: [SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Dave Page
On Mon, May 18, 2009 at 1:29 PM, Gerardo Herzig wrote: > I think this is a good time to propose some kind of CookBook, to > preserve this kind of answers. What, like this one? http://wiki.postgresql.org/wiki/Snippets :-) -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent v

[SQL] proposal for a CookBook in postgresql.org

2009-05-18 Thread Gerardo Herzig
I just saw a beatifull answer from Pavel, as an answer to this question: """ I'm just wondering if there's some way to retrieve the hour column as the > sum of the array values... Just like this: > >hour| statistics_date > +- > 90