Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3f936aa

Browse files
committed
Add a "LIKE = typename" clause to CREATE TYPE for base types. This allows
the basic representational details (typlen, typalign, typbyval, typstorage)to be copied from an existing type rather than listed explicitly in theCREATE TYPE command. The immediate reason for this is to provide a simplesolution for add-on modules that want to define types represented as int8,float4, or float8: as of 8.4 the appropriate PASSEDBYVALUE setting isplatform-specific and so it's hard for a SQL script to know what to do.This patch fixes the contrib/isn breakage reported by Rushabh Lathia.
1 parent0ddede5 commit3f936aa

File tree

3 files changed

+208
-111
lines changed

3 files changed

+208
-111
lines changed

‎contrib/isn/isn.sql.in

Lines changed: 9 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
/* $PostgreSQL: pgsql/contrib/isn/isn.sql.in,v 1.8 2007/11/13 04:24:28 momjian Exp $ */
1+
/* $PostgreSQL: pgsql/contrib/isn/isn.sql.in,v 1.9 2008/11/30 19:01:29 tgl Exp $ */
22

33
-- Adjust this setting to control where the objects get created.
44
SET search_path = public;
@@ -28,9 +28,7 @@ CREATE OR REPLACE FUNCTION ean13_out(ean13)
2828
CREATE TYPE ean13 (
2929
INPUT = ean13_in,
3030
OUTPUT = ean13_out,
31-
INTERNALLENGTH = 8,
32-
ALIGNMENT = double,
33-
STORAGE = PLAIN
31+
LIKE = pg_catalog.int8
3432
);
3533
COMMENT ON TYPE ean13
3634
IS 'International European Article Number (EAN13)';
@@ -48,9 +46,7 @@ CREATE OR REPLACE FUNCTION ean13_out(isbn13)
4846
CREATE TYPE isbn13 (
4947
INPUT = isbn13_in,
5048
OUTPUT = ean13_out,
51-
INTERNALLENGTH = 8,
52-
ALIGNMENT = double,
53-
STORAGE = PLAIN
49+
LIKE = pg_catalog.int8
5450
);
5551
COMMENT ON TYPE isbn13
5652
IS 'International Standard Book Number 13 (ISBN13)';
@@ -68,9 +64,7 @@ CREATE OR REPLACE FUNCTION ean13_out(ismn13)
6864
CREATE TYPE ismn13 (
6965
INPUT = ismn13_in,
7066
OUTPUT = ean13_out,
71-
INTERNALLENGTH = 8,
72-
ALIGNMENT = double,
73-
STORAGE = PLAIN
67+
LIKE = pg_catalog.int8
7468
);
7569
COMMENT ON TYPE ismn13
7670
IS 'International Standard Music Number 13 (ISMN13)';
@@ -88,9 +82,7 @@ CREATE OR REPLACE FUNCTION ean13_out(issn13)
8882
CREATE TYPE issn13 (
8983
INPUT = issn13_in,
9084
OUTPUT = ean13_out,
91-
INTERNALLENGTH = 8,
92-
ALIGNMENT = double,
93-
STORAGE = PLAIN
85+
LIKE = pg_catalog.int8
9486
);
9587
COMMENT ON TYPE issn13
9688
IS 'International Standard Serial Number 13 (ISSN13)';
@@ -110,9 +102,7 @@ CREATE OR REPLACE FUNCTION isn_out(isbn)
110102
CREATE TYPE isbn (
111103
INPUT = isbn_in,
112104
OUTPUT = isn_out,
113-
INTERNALLENGTH = 8,
114-
ALIGNMENT = double,
115-
STORAGE = PLAIN
105+
LIKE = pg_catalog.int8
116106
);
117107
COMMENT ON TYPE isbn
118108
IS 'International Standard Book Number (ISBN)';
@@ -130,9 +120,7 @@ CREATE OR REPLACE FUNCTION isn_out(ismn)
130120
CREATE TYPE ismn (
131121
INPUT = ismn_in,
132122
OUTPUT = isn_out,
133-
INTERNALLENGTH = 8,
134-
ALIGNMENT = double,
135-
STORAGE = PLAIN
123+
LIKE = pg_catalog.int8
136124
);
137125
COMMENT ON TYPE ismn
138126
IS 'International Standard Music Number (ISMN)';
@@ -150,9 +138,7 @@ CREATE OR REPLACE FUNCTION isn_out(issn)
150138
CREATE TYPE issn (
151139
INPUT = issn_in,
152140
OUTPUT = isn_out,
153-
INTERNALLENGTH = 8,
154-
ALIGNMENT = double,
155-
STORAGE = PLAIN
141+
LIKE = pg_catalog.int8
156142
);
157143
COMMENT ON TYPE issn
158144
IS 'International Standard Serial Number (ISSN)';
@@ -170,9 +156,7 @@ CREATE OR REPLACE FUNCTION isn_out(upc)
170156
CREATE TYPE upc (
171157
INPUT = upc_in,
172158
OUTPUT = isn_out,
173-
INTERNALLENGTH = 8,
174-
ALIGNMENT = double,
175-
STORAGE = PLAIN
159+
LIKE = pg_catalog.int8
176160
);
177161
COMMENT ON TYPE upc
178162
IS 'Universal Product Code (UPC)';

‎doc/src/sgml/ref/create_type.sgml

Lines changed: 33 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_type.sgml,v 1.78 2008/11/14 10:22:46 petere Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_type.sgml,v 1.79 2008/11/30 19:01:29 tgl Exp $
33
PostgreSQL documentation
44
-->
55

@@ -39,6 +39,7 @@ CREATE TYPE <replaceable class="parameter">name</replaceable> (
3939
[ , PASSEDBYVALUE ]
4040
[ , ALIGNMENT = <replaceable class="parameter">alignment</replaceable> ]
4141
[ , STORAGE = <replaceable class="parameter">storage</replaceable> ]
42+
[ , LIKE = <replaceable class="parameter">like_type</replaceable> ]
4243
[ , CATEGORY = <replaceable class="parameter">category</replaceable> ]
4344
[ , PREFERRED = <replaceable class="parameter">preferred</replaceable> ]
4445
[ , DEFAULT = <replaceable class="parameter">default</replaceable> ]
@@ -290,6 +291,21 @@ CREATE TYPE <replaceable class="parameter">name</replaceable>
290291
<literal>external</literal> items.)
291292
</para>
292293

294+
<para>
295+
The <replaceable class="parameter">like_type</replaceable> parameter
296+
provides an alternative method for specifying the basic representation
297+
properties of a data type: copy them from some existing type. The values of
298+
<replaceable class="parameter">internallength</replaceable>,
299+
<replaceable class="parameter">passedbyvalue</replaceable>,
300+
<replaceable class="parameter">alignment</replaceable>, and
301+
<replaceable class="parameter">storage</replaceable> are copied from the
302+
named type. (It is possible, though usually undesirable, to override
303+
some of these values by specifying them along with the <literal>LIKE</>
304+
clause.) Specifying representation this way is especially useful when
305+
the low-level implementation of the new type <quote>piggybacks</> on an
306+
existing type in some fashion.
307+
</para>
308+
293309
<para>
294310
The <replaceable class="parameter">category</replaceable> and
295311
<replaceable class="parameter">preferred</replaceable> parameters can be
@@ -524,6 +540,22 @@ CREATE TYPE <replaceable class="parameter">name</replaceable>
524540
</listitem>
525541
</varlistentry>
526542

543+
<varlistentry>
544+
<term><replaceable class="parameter">like_type</replaceable></term>
545+
<listitem>
546+
<para>
547+
The name of an existing data type that the new type will have the
548+
same representation as. The values of
549+
<replaceable class="parameter">internallength</replaceable>,
550+
<replaceable class="parameter">passedbyvalue</replaceable>,
551+
<replaceable class="parameter">alignment</replaceable>, and
552+
<replaceable class="parameter">storage</replaceable>
553+
are copied from that type, unless overridden by explicit
554+
specification elsewhere in this <command>CREATE TYPE</> command.
555+
</para>
556+
</listitem>
557+
</varlistentry>
558+
527559
<varlistentry>
528560
<term><replaceable class="parameter">category</replaceable></term>
529561
<listitem>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp