Search Postgresql Archives

Re: SQL function and input variables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux