MIME-Version: 1.0
In-Reply-To: <CA+FnnTye9NG93Bdp02qKcaKgdOzEMazhs9DNxZ8DMw9mcRXHjA@mail.gmail.com>
References: <CA+FnnTw=18Rba2XgceRUFKQo5P7Xf9QhXT6wKF=DgzYT6K9-sw@mail.gmail.com>
 <CAKFQuwa0QT01k7yVQJOQ2oMeQQWOQ+NSeYYyY3-8sqNYLQvBOA@mail.gmail.com> <CA+FnnTye9NG93Bdp02qKcaKgdOzEMazhs9DNxZ8DMw9mcRXHjA@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 9 Dec 2025 06:43:57 -0700
Message-ID: <CAKFQuwZeOqHpV4jpRWQPzfCPnM7Asz9t11+L2Fd=7UA2kTaGNA@mail.gmail.com>
Subject: Re: How do I check for NULL
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000089a9b00645851a64"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZeOqHpV4jpRWQPzfCPnM7Asz9t11%2BL2Fd%3D7UA2kTaGNA%40mail.gmail.com>
Precedence: bulk

--00000000000089a9b00645851a64
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Tuesday, December 9, 2025, Igor Korot <ikorot01@gmail.com> wrote:

> Hi, Davd,
>
> On Mon, Dec 8, 2025 at 6:44=E2=80=AFPM David G. Johnston
> <david.g.johnston@gmail.com> wrote:
> >
> > On Monday, December 8, 2025, Igor Korot <ikorot01@gmail.com> wrote:
> >>
> >>
> >> However,, I'd like to still insert the record and I'd like to do
> something like:
> >>
> >> INSERT INTO test VALUES( 0, 'abc', 12345, IF( (SELECT foo FROM bar) =
=3D=3D
> >> NULL, "postgres", <select_result>), /*more data follow*/);
> >>
> >> What would be the best way to achieve this?
> >
> >
> > The =E2=80=9Ccoalesce=E2=80=9D function.
>
> This is the query I use for my ODBC calls:
>
>             qry2 =3D L"INSERT INTO \"test\" VALUES( ?, ?, (SELECT c.oid
> FROM pg_class c, pg_namespace nc WHERE nc.oid =3D c.relnamespace AND
> c.relname =3D ? AND nc.nspname =3D ?), COALESCE((SELECT tableowner FROM
> pg_tables WHERE tablename =3D ? AND schemaname =3D ?), \"postgres\"), ...=
)
> ON CONFLICT DO NOTHING;";
>
> Calling SQLExecute after parameter binding results in
>
> "L"ERROR: column \"postgres\" does not exist;\nError while preparing
> parameters"std::basic_string<wchar_t,std::char_traits<
> wchar_t>,std::allocator<wchar_t>
>
>
Use single quotes for a string literal value.

David J.

--00000000000089a9b00645851a64
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<br>Tuesday, December 9, 2025, Igor Korot &lt;<a href=3D"mailto:ikorot01@gm=
ail.com">ikorot01@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
">Hi, Davd,<br>
<br>
On Mon, Dec 8, 2025 at 6:44=E2=80=AFPM David G. Johnston<br>
&lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.co=
m</a>&gt; wrote:<br>
&gt;<br>
&gt; On Monday, December 8, 2025, Igor Korot &lt;<a href=3D"mailto:ikorot01=
@gmail.com">ikorot01@gmail.com</a>&gt; wrote:<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; However,, I&#39;d like to still insert the record and I&#39;d like=
 to do something like:<br>
&gt;&gt;<br>
&gt;&gt; INSERT INTO test VALUES( 0, &#39;abc&#39;, 12345, IF( (SELECT foo =
FROM bar) =3D=3D<br>
&gt;&gt; NULL, &quot;postgres&quot;, &lt;select_result&gt;), /*more data fo=
llow*/);<br>
&gt;&gt;<br>
&gt;&gt; What would be the best way to achieve this?<br>
&gt;<br>
&gt;<br>
&gt; The =E2=80=9Ccoalesce=E2=80=9D function.<br>
<br>
This is the query I use for my ODBC calls:<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 qry2 =3D L&quot;INSERT INTO \&quo=
t;test\&quot; VALUES( ?, ?, (SELECT c.oid<br>
FROM pg_class c, pg_namespace nc WHERE nc.oid =3D c.relnamespace AND<br>
c.relname =3D ? AND nc.nspname =3D ?), COALESCE((SELECT tableowner FROM<br>
pg_tables WHERE tablename =3D ? AND schemaname =3D ?), \&quot;postgres\&quo=
t;), ...)<br>
ON CONFLICT DO NOTHING;&quot;;<br>
<br>
Calling SQLExecute after parameter binding results in<br>
<br>
&quot;L&quot;ERROR: column \&quot;postgres\&quot; does not exist;\nError wh=
ile preparing<br>
parameters&quot;std::basic_string&lt;<wbr>wchar_t,std::char_traits&lt;<wbr>=
wchar_t&gt;,std::allocator&lt;wchar_<wbr>t&gt;<br><br>
</blockquote><div><br></div><div>Use single quotes for a string literal val=
ue.</div><div><br></div><div>David J.</div><div>=C2=A0</div>

--00000000000089a9b00645851a64--