From: | "Guillermo E(dot) Villanueva" <guillermovil(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Fwd: Bug? |
Date: | 2015-04-01 11:48:28 |
Message-ID: | CANm+PCCehFbbCZL3QF47kR_VOrFSLHf6o8M1e3HHfLO9qhbneg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ashesh Vashi | 2015-04-01 12:02:34 | Re: Fwd: Bug? |
Previous Message | Paolo Saudin | 2015-03-31 05:32:10 | Re: feature request: "copy" full text |