Message-ID: <559E80E0.8000002@postgrespro.ru>
Date: Thu, 09 Jul 2015 17:10:40 +0300
From: Alex Ignatov <a.ignatov@postgrespro.ru>
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: "David G. Johnston" <david.g.johnston@gmail.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Strange DOMAIN behavior
References: <559E470F.6020002@postgrespro.ru>
 <CAKFQuwYOZQ22qNtPe0m4w047DLhnDati8+Yqhcd6S2SOYL2GDQ@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwYOZQ22qNtPe0m4w047DLhnDati8+Yqhcd6S2SOYL2GDQ@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------030109080309080509030600"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------030109080309080509030600
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Thank you for your reply.
In fact i want to use domains in the following case:

DROP DOMAIN lexema_str CASCADE;
CREATE DOMAIN lexema_str TEXT DEFAULT 'abc' NOT NULL;
DROP TYPE lexema_test CASCADE;
CREATE TYPE lexema_test AS (
    lex  lexema_str,
    lex2 BIGINT
);
DROP TABLE ttt;
CREATE TABLE ttt (
    a lexema_test,
    b BIGINT
);
INSERT INTO ttt (b) VALUES (1);
SELECT *
FROM ttt;
  a | b
---+---
    | 1
(1 row)

  a.lex is null  again not 'abc' as I expected like in plpgsql.

All i want is to have default values in composite types. Feature that 
Oracle have.
I thought that with domain type it should be possible.


On 09.07.2015 15:49, David G. Johnston wrote:
> On Thursday, July 9, 2015, Alex Ignatov <a.ignatov@postgrespro.ru 
> <javascript:_e(%7B%7D,'cvml','a.ignatov@postgrespro.ru');>> wrote:
>
>     Hello everyone!!!
>     Got strange DOMAIN behavior in the following plpgsql code:
>
>     But i expect that lex = abc!
>
>     So default value of DOMAIN type is not set in pgplsql block but:
>
>     Is this correct behavior??
>
>
> If you read the create domain sql command documentation carefully the 
> default clause is only used when inserting into a table that has a 
> column of the domain type that is not explicitly provided a value.  
> Each language deals with domains differently and the behavior you 
> expect is not currently implemented in pl/pgsql.  If you want a 
> default inside the procedure you need to declare one explicitly.
>
> David J.

-- 
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--------------030109080309080509030600
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Thank you for your reply.<br>
    In fact i want to use domains in the following case:<br>
    <br>
    DROP DOMAIN lexema_str CASCADE;<br>
    CREATE DOMAIN lexema_str TEXT DEFAULT 'abc' NOT NULL;<br>
    DROP TYPE lexema_test CASCADE;<br>
    CREATE TYPE lexema_test AS (<br>
       lex  lexema_str,<br>
       lex2 BIGINT<br>
    );<br>
    DROP TABLE ttt;<br>
    CREATE TABLE ttt (<br>
       a lexema_test,<br>
       b BIGINT<br>
    );<br>
    INSERT INTO ttt (b) VALUES (1);<br>
    SELECT *<br>
    FROM ttt;<br>
     a | b<br>
    ---+---<br>
       | 1<br>
    (1 row)<br>
    <br>
     a.lex is null  again not 'abc' as I expected like in plpgsql. <br>
    <br>
    All i want is to have default values in composite types. Feature
    that Oracle have.<br>
    I thought that with domain type it should be possible.<br>
    <br>
    <br>
    <br>
    <br>
    <br>
    <div class="moz-cite-prefix">On 09.07.2015 15:49, David G. Johnston
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAKFQuwYOZQ22qNtPe0m4w047DLhnDati8+Yqhcd6S2SOYL2GDQ@mail.gmail.com"
      type="cite">On Thursday, July 9, 2015, Alex Ignatov &lt;<a
        moz-do-not-send="true"
        href="javascript:_e(%7B%7D,'cvml','a.ignatov@postgrespro.ru');"
        target="_blank">a.ignatov@postgrespro.ru</a>&gt; wrote:<br>
      <blockquote class="gmail_quote" style="margin:0 0 0
        .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello
        everyone!!!<br>
        Got strange DOMAIN behavior in the following plpgsql code:<br>
        <br>
        But i expect that lex = abc!<br>
        <br>
        So default value of DOMAIN type is not set in pgplsql block but:<br>
        <br>
        Is this correct behavior??<br>
        <br>
      </blockquote>
      <div><br>
      </div>
      <div>If you read the create domain sql command documentation
        carefully the default clause is only used when inserting into a
        table that has a column of the domain type that is not
        explicitly provided a value.  Each language deals with domains
        differently and the behavior you expect is not currently
        implemented in pl/pgsql.  If you want a default inside the
        procedure you need to declare one explicitly.</div>
      <div><br>
      </div>
      <div>David J.</div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Alex Ignatov
Postgres Professional: <a class="moz-txt-link-freetext" href="http://www.postgrespro.com">http://www.postgrespro.com</a>
The Russian Postgres Company

</pre>
  
<br /><br />
<hr style='border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;' />
<table style='border-collapse:collapse;border:none;'>
	<tr>
		<td style='border:none;padding:0px 15px 0px 8px'>
			<a href="https://www.avast.com/antivirus">
				<img border=0 src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo" />
			</a>
		</td>
		<td>
			<p style='color:#3d4d5a; font-family:"Calibri","Verdana","Arial","Helvetica"; font-size:12pt;'>
				This email has been checked for viruses by Avast antivirus software.
				<br><a href="https://www.avast.com/antivirus">www.avast.com</a>
			</p>
		</td>
	</tr>
</table>
<br />
</body>
</html>

--------------030109080309080509030600--