You can do something like: DECLARE p ALIAS FOR $1; in the function, if you want. Susan -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Martín Marqués Sent: Wednesday, September 21, 2011 6:09 AM To: Thomas Kellerer Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: SQL function and input variables 2011/9/21 Thomas Kellerer <spam_eater@xxxxxxx>: > Martín Marqués, 21.09.2011 14:56: >> >> 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? >> > This is because the language SQL does not support named parameters, only > positional ones. > > http://www.postgresql.org/docs/current/static/xfunc-sql.html#XFUNC-NAMED-PARAMETERS Thanks for the tip. Didn't know that, and just kept using plpgsql sintax. Thanks again. -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
