Hi Dave and pgadmin team, how are you?
First of all I want to thank you for the pgAdmin software, it's great.
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
