S.O. client: Windows 7 pgAdmin III: 1.20.0 Server: win/lnx 9.0.13/9.0.5 Guillermo Villanueva
2015-04-01 9:02 GMT-03:00 Ashesh Vashi <ashesh.va...@enterprisedb.com>: > On Wed, Apr 1, 2015 at 5:18 PM, Guillermo E. Villanueva < > guillermo...@gmail.com> wrote: > >> Hi Dave and pgadmin team, how are you? >> First of all I want to thank you for the pgAdmin software, it's great. >> > Version of pgAdmin? > > -- > > Thanks & Regards, > > Ashesh Vashi > EnterpriseDB INDIA: Enterprise PostgreSQL Company > <http://www.enterprisedb.com> > > > *http://www.linkedin.com/in/asheshvashi* > <http://www.linkedin.com/in/asheshvashi> > > >> I think I detected an error. The explanation Is here: >> >> *In pgAdmin III* >> >> I select one function from the Object browser and I can see source code >> in SQL Pane: >> >> [image: Imágenes integradas 1] >> >> *In psql:* >> >> nacer=# \df+ nacer.periodos; >> >> List of functions >> >> -[ RECORD 1 >> ]-------+------------------------------------------------------------------------------------------------- >> >> Schema | nacer >> >> Name | periodos >> >> *Result data type | TABLE(per_fecha timestamp without time zone)* >> >> Argument data types | >> >> Type | normal >> >> Volatility | volatile >> >> Owner | postgres >> >> Language | plpgsql >> >> Source code | >> >> | declare >> >> | lts_minimo timestamp; >> >> | lts_maximo timestamp; >> >> | begin >> >> | select max(periodo), min(periodo) into lts_maximo, >> lts_minimo from nacer.historicotemp; >> >> | RETURN QUERY select * from >> generate_series(lts_minimo, lts_maximo,'1 month'::interval); >> >> | end; >> >> | >> >> Description | >> I hope your comments. >> >> Sorry for my english. >> >> Guillermo Villanueva >> Salta - Argentina >> >> >
