pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: pashaharkov@yandex.ru
Subject: BUG #18393: Bad multiple "inplace" insert into domain of complex type
Date: Thu, 14 Mar 2024 06:21:16 +0000
Message-ID: <18393-65fedb1a0de9260d@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      18393
Logged by:          Pablo Kharo
Email address:      pashaharkov@yandex.ru
PostgreSQL version: 16.2
Operating system:   Mac OS 14.1
Description:        

Hi, i have found strange thing when was using domain of complex type.

When i was using insert like this to domain of type:
```
CREATE TYPE user_tp AS (
    uid          TEXT,
    email        text,
    timestamp TIMESTAMP
);

create domain user_domain as public.user_tp;

CREATE TABLE comps_tb (
    id  	SERIAL PRIMARY KEY,
    us  	user_domain NOT NULL
);

insert into public.comps_tb 
(
	us.uid,
	us.email
)
values 
(
	'213'::TEXT, 
	'email'::TEXT
),
(
	'321'::TEXT, 
	'email2'::TEXT
);

select 
	id,
	(us).uid,
	(us).email 
from 
	public.comps_tb;
```

I have output like this:
id|uid    |email     |
--+-------+----------+
 1|(213,,)|(,email,) |
 2|(321,,)|(,email2,)|

But i expecting 
id|uid    |email     |
--+-------+----------+
 1|213|email |
 2|321|email2|


So, it has created additional brackets in uid and email. BUT if i inserting
into this table only one element, it inserts without additional brackets. 
Also additional brackets are not creating when i am using complex type
itself - not domain,



view thread (2+ messages)  latest in thread

Message-ID: <18393-65fedb1a0de9260d@postgresql.org>
Permalink:  ../18393-65fedb1a0de9260d@postgresql.org/
Also on:    postgresql.org/message-id/18393-65fedb1a0de9260d@postgresql.org

 · 

reply

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-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, pashaharkov@yandex.ru
  Subject: Re: BUG #18393: Bad multiple "inplace" insert into domain of complex type
  In-Reply-To: <18393-65fedb1a0de9260d@postgresql.org>

* 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