Re: Error updating column of type text as boolean type

Tank you Mckown.

Em qua, 3 de jul de 2019 às 12:15, John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com>
escreveu:

> On Wed, Jul 3, 2019 at 10:09 AM Marllius <marllius(at)gmail(dot)com> wrote:
>
>> Hi guys, I was looking datatype bugs for postgresql 10.6 but i not found
>> anything.
>>
>> I am trying to update the column of type text column but i get an error
>> for boolean type. In other tables the behavior of the text type column is
>> normal.
>>
>> Has anyone had this problem before?
>>
>> accounting(at)accounting=> \dS+ stock_asset_document
>> Table
>> "public.stock_asset_document"
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> * Column | Type | Collation | Nullable |
>> Default | Storage | Stats target |
>> Description
>> ----------------+--------------------------+-----------+----------+-----------------------------------------------+----------+--------------+------------- id
>> | bigint | | not null |
>> nextval('seq_stock_asset_document'::regclass) | plain | |
>> tenant_id | bigint | | not null |
>> | plain | |
>> registry_id | uuid | | not null |
>> | plain | |
>> revision_id | uuid | | not null |
>> | plain | |
>> negotiation_id | bigint | | not null |
>> | plain | |
>> competence_at | date | | not null |
>> | plain | |
>> is_deleted | boolean | | not null |
>> | plain | |
>> created_at | timestamp with time zone | | not null | now()
>> | plain | |
>> updated_at | timestamp with time zone | | |
>> | plain | | number
>> | bigint | | |
>> | plain | | serial |
>> text | | |
>> | extended | | *
>> Indexes:
>> "pk_stock_asset_document" PRIMARY KEY, btree (id)
>> "uk_stock_asset_document_registry_revision" UNIQUE CONSTRAINT, btree
>> (registry_id, revision_id)
>> "ix_stock_asset_document_tenant_deleted" btree (tenant_id, is_deleted)
>> "ix_stock_asset_document_tenant_registry_revision_deleted" btree
>> (tenant_id, registry_id, revision_id, is_deleted)
>> Referenced by:
>> TABLE "stock_asset" CONSTRAINT
>> "fk_stock_asset_entry_stock_asset_document" FOREIGN KEY (entry_document_id)
>> REFERENCES stock_asset_document(id) ON UPDATE RESTRICT ON DELETE RESTRICT
>> TABLE "stock_asset" CONSTRAINT
>> "fk_stock_asset_output_stock_asset_document" FOREIGN KEY
>> (output_document_id) REFERENCES stock_asset_document(id) ON UPDATE RESTRICT
>> ON DELETE RESTRICT
>>
>> accounting(at)accounting=> UPDATE stock_asset_document SET serial = '3' AND
>> number = 36245 WHERE negotiation_id = 15948333;
>>
>
> Don't use AND. Use a comma:
>
> UPDATE stock_asset_document SET serial = '3', number = 36245 WHERE
> negotiation_id = 15948333;
>
> ref: https://www.postgresql.org/docs/11/sql-update.html
>
>
>
>
>> ERROR: 22P02: invalid input syntax for type boolean: "3"
>> LINE 1: UPDATE stock_asset_document SET serial = '3' AND number = 36...
>> ^
>> LOCATION: boolin, bool.c:154
>> Time: 16.427 ms
>> accounting(at)accounting=> SELECT version();
>> version
>>
>>
>> ---------------------------------------------------------------------------------------------------------
>> PostgreSQL 10.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
>> 20150623 (Red Hat 4.8.5-11), 64-bit
>> (1 row)
>>
>> Time: 15.989 ms
>>
>> Atenciosamente,
>>
>> Márllius de Carvalho Ribeiro
>> [image: EDB Certified Associate - PostgreSQL 10]
>> <https://www.youracclaim.com/badges/c8dd0919-86ca-4cec-9f58-5cd6fb558a91/public_url>
>>
>>
>
> --
> Money is the root of all evil.
> Evil is the root of all money.
> With that in mind, money is made by the government ...
>
>
> Maranatha! <><
> John McKown
>