Re: Need another set of eyes on this

From: "aNullValue (Drew Stemen)" <drew(at)anullvalue(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Need another set of eyes on this
Date: 2021-01-25 19:19:24
Message-ID: a5d0205c-3292-4037-8603-662eb6ec76c9@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 2021-01-25T14:17:42-05:00, James B. Byrne <byrnejb(at)harte-lyne(dot)ca> sent:
> postgres : STATEMENT: INSERT INTO public.stock(
> stock_num, manu_code, description, unit_price, unit, unit_descr)
> VALUES (3, "SHM", "aluminum Bat", 180.00, "case", "12/case");
> postgres : ERROR: 42703: column "SHM" does not exist at character 105
> postgres : LOCATION: errorMissingColumn, parse_relation.c:3194

You're using double-quotes rather than single-quotes for string values.

"SHM" = column
'SHM' = string value

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Coppens 2021-01-25 19:19:59 Re: Need another set of eyes on this
Previous Message James B. Byrne 2021-01-25 19:17:42 Need another set of eyes on this