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: Thu, 12 Feb 2004 13:43:32 +0100
Message-ID: <402B74F4.7070604@klaster.net> (raw)
In-Reply-To: <00c001c3f164$1db30140$7502a8c0@hdsc.com>
References: <00c001c3f164$1db30140$7502a8c0@hdsc.com>
Dnia 2004-02-12 13:31, Użytkownik Kumar napisał:
> The error is because of no value for column c1. If the column c1 is a
> string I might have replace it with empty string. I don't want to
> substitute with '0' which could work.
>
> sqlstr := 'insert into test(c1, c2) values (' ||ISNULL(rec.c1,'0')||','
>
> ||'\''||rec.c2||'\')';
Substitute it with NULL value:
sqlstr := 'insert into test(c1, c2) values(' || coalesce(rec.c1,'NULL')
||...
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: <402B74F4.7070604@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