| From: | "F(dot) BROUARD / SQLpro" <sqlpro(at)club-internet(dot)fr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: moving from MySQL to pgsql |
| Date: | 2012-10-11 06:43:44 |
| Message-ID: | 50766AA0.1030904@club-internet.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Le 10/10/2012 10:47, Vineet Deodhar a écrit :
> Hi !
>
> 3) Can I simulate MySQL's TINYINT data-type (using maybe the custom data
> type or something else)
>
Another way, and a good practice toot is to use SQL DOMAINs wich is a
part of the ISO SQL since 1992 that MySQL don't have...
CREATE DOMAIN TINYINT
AS SMALLINT
CHECK (VALUE BETWEEN 0 AND 255)
Most part of the modelling tools are able to use DOMAINs in their
modelling process, like PowerDesigner, Mega, ERwin, Rational...
A +
--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vineet Deodhar | 2012-10-11 07:04:30 | auto-increment field : in a simple way |
| Previous Message | tigran2-postgres | 2012-10-11 06:14:42 | Storing large files in multiple schemas: BLOB or BYTEA |