Nested Transactions

i'm trying to accomplish the following task:

begin transaction;
        begin work;
                create table xyz(
                  id int
                );
        commit work;
        select * from xyz;
rollback transaction;
select * from xyz;  // should say database object doesn't exist

however i'm failing to be able to do this?? is there a specific reason?

I know in MSSQL you can say:

begin transaction
    begin transaction test
        create table xyz(
            id [int]
        );
        select * from xyz
    commit transaction test
rollback transaction
select * from xyz // database object doesn't exist

Is there an equivalent?

TIA