Re: Correctly quoting inside plpgsql functions - Mailing list pgsql-novice

From Joshua b. Jore
Subject Re: Correctly quoting inside plpgsql functions
Date
Msg-id Pine.BSO.4.40.0204200841320.4381-100000@kitten.greentechnologist.org
Whole thread Raw
In response to Correctly quoting inside plpgsql functions  (alberto bolchini <alberto@melloni49.it>)
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try quote_literal instead.

Joshua b. Jore
http://www.greentechnologist.org

On Sat, 20 Apr 2002, alberto bolchini wrote:

> jsg_2'# ''SELECT * FROM t INNER JOIN i18n ON t.id=i18n.id AND
> i18n.language_id='' || quote_ident(l_lang) || '' ORDER BY description'';

> jsg_2=# select myfun('en',0);
> NOTICE: Error occurred while executing PL/pgSQL function myfun
> NOTICE: line 5 at open
> ERROR: Attribute 'en' not found
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8wXBBfexLsowstzcRArkjAKDJHOgbVyGUz9YYXwX6VJoR23k8YACfVxeO
lJ74TlFfnPByZ+Bhfhi9mUw=
=1Y0e
-----END PGP SIGNATURE-----


pgsql-novice by date:

Previous
From: alberto bolchini
Date:
Subject: Correctly quoting inside plpgsql functions
Next
From: alberto bolchini
Date:
Subject: Re: Correctly quoting inside plpgsql functions