From: Tomasz Myrta <jasiek@klaster.net>
To: Kumar <sgnerd@yahoo.com.sg>
Cc: psql <pgsql-sql@postgresql.org>
Subject: Re: How to avoid nulls while writing string for dynamic query
Date: Fri, 13 Feb 2004 07:33:28 +0100
Message-ID: <402C6FB8.8000606@klaster.net> (raw)
In-Reply-To: <006701c3f1ed$6610dc30$7502a8c0@hdsc.com>
References: <00c001c3f164$1db30140$7502a8c0@hdsc.com>
<402B74F4.7070604@klaster.net>
<006701c3f1ed$6610dc30$7502a8c0@hdsc.com>
Dnia 2004-02-13 05:53, Użytkownik Kumar napisał:
> I am having problem there. see what happens
>
> sqlstr := 'insert into test(c1, c2) values ('||COALESCE(rec.c1,'NULL')||','
> ||'\''||rec.c2||'\')';
You are preparing a string, so make sure you have strings everywhere:
sqlstr := 'insert into test(c1, c2) values
('||COALESCE(rec.c1::text,'NULL')||','||'\''||rec.c2||'\')';
Regards,
Tomasz Myrta
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasiek@klaster.net, sgnerd@yahoo.com.sg
Subject: Re: How to avoid nulls while writing string for dynamic query
In-Reply-To: <402C6FB8.8000606@klaster.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox