Skip to content

Tag Archives: Example

Useful or useless? Follow on post …

23-Feb-10

Way back in May last year I experimented with some IMA tables that showed data types and operators defined in the DBMS.  Further poking around and a table for a list of the function instances is available, drop ima_dbms_fis; \p\g register table ima_dbms_fis ( server varchar(64) not null not default is ‘SERVER’, id integer4 not [...]

Enhanced Row producing procedures

14-Nov-08

I was recently asked about the ability to run a row producing procedure from anything other than ESQLC, which reminded me of a couple of feature requests that I have recently made http://community.ingres.com/wiki/Table_Procedure_Enhancements, named result columns for a row producing procedure and the ability to use a row producing procedure in a view definition.  In [...]