| From: | "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org> |
|---|---|
| To: | alberto bolchini <alberto(at)melloni49(dot)it> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Correctly quoting inside plpgsql functions |
| Date: | 2002-04-20 13:42:21 |
| Message-ID: | Pine.BSO.4.40.0204200841320.4381-100000@kitten.greentechnologist.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | alberto bolchini | 2002-04-20 14:08:42 | Re: Correctly quoting inside plpgsql functions |
| Previous Message | alberto bolchini | 2002-04-20 10:47:23 | Correctly quoting inside plpgsql functions |