> -----Original Message-----
> From: Mark Rotteveel [mailto:[email protected]] 
> Sent: MiƩrcoles, 07 de Mayo de 2014 13:56
> >
> > SQL> set recordbuf on;
> > SQL> select first 3 rdb$trigger_name, rdb$relation_name 
> from rdb$triggers;
> >
> > RDB$TRIGGER_NAME RDB$RELATION_NAME
> > ================ ===================
> > RDB$TRIGGER_1    RDB$USER_PRIVILEGES
> > RDB$TRIGGER_8    RDB$USER_PRIVILEGES
> > RDB$TRIGGER_9    RDB$USER_PRIVILEGES
> >
> > SQL>
> >
> > I think the difference is evident.
> >
> 
> Nice :)

Hello, Mark. As a geek exercise is good, but I think some of the qualities
of this feature would make Helen wish to hit me with a heavy SQL book:

******
SQL> set recordbuf on;
SQL> select first 5 rdb$relation_name, null, 1 from rdb$relations;

RDB$RELATION_NAME      CONSTANT
================== ============
RDB$PAGES                     1
RDB$DATABASE                  1
RDB$FIELDS                    1
RDB$INDEX_SEGMENTS            1
RDB$INDICES                   1

Full NULL columns hidden due to RecordBuff: 1
*******

I don't know if this is useful to anyone, but I did it to see only relevant
information in interactive sessions.

C.


------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to