On 21/09/2011 13:56, Martín Marqués wrote: > I was makeing an SQL function and got an error which on a sintax that > I thouhgt would work: > > CREATE OR REPLACE FUNCTION dicInsertarPalabra(p TEXT) > RETURNS INT AS $body$ > INSERT INTO public.diccionario (palabra) VALUES (quote_literal(p)); > SELECT COALESCE(codigo,0) FROM public.diccionario > WHERE palabra = quote_literal(p); > $body$ LANGUAGE 'SQL'; > > Changing p for $1 in the body of the function makes it work. But, > can't we label input arguments like how I did here? >
No, you can't - that works in pl/pgsql, but not in SQL. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
