From: | Rodrigo Gonzalez <rjgonzale(at)estrads(dot)com(dot)ar> |
---|---|
To: | ruben avila galindo <ruben2218(at)gmail(dot)com> |
Cc: | Jaime Casanova <jaime(at)2ndquadrant(dot)com>, pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Execute SQL en Function |
Date: | 2011-11-29 17:58:03 |
Message-ID: | 4ED51D2B.80709@estrads.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
On 11/29/2011 02:33 PM, ruben avila galindo wrote:
> asi le mando a la funcion
>
> select * from sch_rpt.fun_ventas(1,1,'2011-11-24
> 07:00:00',null,null,null,101)
>
> ERROR: syntax error at or near "07"
>
> LINE 10: ..._maq_casino = 101and fecha >=2011-11-24 07:00:00-0...
>
SSQL = SSQL || 'and fecha tiene que ser
SSQL = SSQL || ' and fecha (mira el espacio antes del and)
Saludos
Rodrigo
>
> ^
>
> 2011/11/29 Jaime Casanova <jaime(at)2ndquadrant(dot)com
> <mailto:jaime(at)2ndquadrant(dot)com>>
>
> On Tue, Nov 29, 2011 at 12:20 PM, ruben avila galindo
> <ruben2218(at)gmail(dot)com <mailto:ruben2218(at)gmail(dot)com>> wrote:
> > SSQL = SSQL || 'and fecha
> >='|| to_timestamp(arg_fecha,'YYYY-MM-DD HH:MM:SS')
>
> esyo deberia decir:
> to_timestamp(arg_fecha,'YYYY-MM-DD HH:MI:SS')
>
> --
> Jaime Casanova www.2ndQuadrant.com <http://www.2ndQuadrant.com>
> Professional PostgreSQL: Soporte 24x7 y capacitación
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2011-11-29 18:15:47 | Re: Execute SQL en Function |
Previous Message | ruben avila galindo | 2011-11-29 17:33:23 | Re: Execute SQL en Function |