Thread: quote_literal
CREATE OR REPLACE FUNCTION "scheme"."function" (var varchar) RETURNS varchar AS DECLARE res varchar; BEGIN /* Which is correct? This: */ SELECT col1 FROM table WHERE col2=var INTO res; /*Or this:*/ SELECT col1 FROM table WHERE col2=quote_literal(var) INTO res; RETURN res; END;
Hello this is correct SELECT col1 FROM table WHERE col2=var INTO res; Regards Pavel Stehule 2011/1/14 tbazadaykin <tbazadaykin@yandex.ru>: > CREATE OR REPLACE FUNCTION "scheme"."function" (var varchar) RETURNS varchar AS > DECLARE > res varchar; > BEGIN > /* Which is correct? This: */ > > /*Or this:*/ > SELECT col1 FROM table WHERE col2=quote_literal(var) INTO res; > RETURN res; > END; > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >