Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] SQL function and input variables
2011/9/21 Thomas Kellerer :
> 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:
>>
&g
Thomas Kellerer writes:
> 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 (
2011/9/21 Thomas Kellerer :
> 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
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 COA
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));
>
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.dicciona
