Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Generate DDL Function - Postgres (when i generate DDL Function Postgres, dont have the SQL)
Generate DDL Function - Postgres [message #1164666] Thu, 31 October 2013 21:06
Levine Gurgel is currently offline Levine Gurgel
Messages: 1
Registered: October 2013
Junior Member
hi, how can i Generate DDL of Function in "Data Source Explorer" at DTP with Postgres? when i generate there, dont have the SQL:

--<ScriptOptions statementTerminator=";"/>

CREATE FUNCTION public.city(
IN name TEXT,)
RETURNS boolean
NOT DETERMINISTIC

NO_SQL

CALLED ON NULL INPUT;

The same function generated from the pgadmin for exemplo:



CREATE OR REPLACE FUNCTION public.city(name varchar)
RETURNS boolean AS
$BODY$
DECLARE
id integer;
BEGIN
INSERT INTO public.city (name)
VALUES(name);
RETURN true;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION public.city(varchar)
OWNER TO postgres;


Previous Topic:Parser Generator LPG Version 2.2
Next Topic:SQL editor line lmit by 500
Goto Forum:
  


Current Time: Sat Sep 20 05:54:58 GMT 2014

Powered by FUDForum. Page generated in 0.02412 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software