Extended SQL

[Shmuel]

Is there a way of creating a your own types in mysql:

address ROW(
name VARCHAR(64),
street VARCHAR(64),
postage VARCHAR(64)
);

And does it support ARRAY or CREATE TYPE OR CREATE METHOD
or similar ?

Shmuel.

[Lukas Bradley]

No to the first question. Data types are not supported.

If you are trying to create a stored procedure, then MySQL 5 alphas might
help you.

1.8.4.4 Stored Procedures and Triggers

Stored procedures are being implemented in our version 5.0 development tree.
See section 2.3.4 Installing from the Development Source Tree.

This effort is based on SQL-99, which has a basic syntax similar (but not
identical) to Oracle PL/SQL. In addition to this, we are implementing the
SQL-99 framework to hook in external languages.

http://www.mysql.com/documentation/index.html
Lukas

"Shmuel" <sa***@vectorstar.net> wrote in message
news:u8**************@reader1.news.jippii.net...

Is there a way of creating a your own types in mysql:

address ROW(
name VARCHAR(64),
street VARCHAR(64),
postage VARCHAR(64)
);

And does it support ARRAY or CREATE TYPE OR CREATE METHOD
or similar ?

Shmuel.

[Lukas Bradley]

No to the first question. Data types are not supported.

If you are trying to create a stored procedure, then MySQL 5 alphas might
help you.

1.8.4.4 Stored Procedures and Triggers

Stored procedures are being implemented in our version 5.0 development tree.
See section 2.3.4 Installing from the Development Source Tree.

This effort is based on SQL-99, which has a basic syntax similar (but not
identical) to Oracle PL/SQL. In addition to this, we are implementing the
SQL-99 framework to hook in external languages.

http://www.mysql.com/documentation/index.html
Lukas

"Shmuel" <sa***@vectorstar.net> wrote in message
news:u8**************@reader1.news.jippii.net...

Is there a way of creating a your own types in mysql:

address ROW(
name VARCHAR(64),
street VARCHAR(64),
postage VARCHAR(64)
);

And does it support ARRAY or CREATE TYPE OR CREATE METHOD
or similar ?

Shmuel.