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-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: > 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: [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.

[SQL] complex column definition in query

2009-06-02 Thread Seb
Hi, Say we have a table: SELECT * FROM weather; city | temp_lo | temp_hi | prcp ---+-+-+--- San Francisco | 46 | 50 | 0.25 San Francisco | 43 | 57 |0 Hayward | 37 | 54 | Hayward | 30 |

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: