Snippets

Home / Snippets / Store Procedure

Store Procedure

Snippet Menu

snippet |

revisions |

comments | Related Snippets

related |

Add to Favorites | Email

download | Print

print | Blog It

blog it

Mon. Jun. 9th, 2008 6:54 PM

1 of 1

vertxch

postgresql | procedure | store

0 comments

Store Procedure en PostgreSql 8.2
/* CREAR UN SP PARA OBTENER TOTAL IMPORTE POR DESTINO*/

CREATE OR REPLACE FUNCTION spimptotxdes(varchar(50))

RETURNS numeric(9,2)

AS'

        DECLARE

                vdestino ALIAS FOR $1;

                vimptot numeric(9,2);

        BEGIN

                SELECT INTO vimptot sum(importe)

                FROM tembarque

                WHERE destino=vdestino;

                RETURN vimptot;

        END;

' LANGUAGE 'plpgsql';