Hi Daniel,

> Hi Martijn, I spend at least 30% of my daily time "dancing with PL/SQL".
>
> Personally I think using domains would be more "elegant". Your

"table.column%TYPE"

> suggestion would resolve many cases. Maybe it's not as purist as a domain

(you need

> to anchor your code to one specific table/column) but would be a major

improvement

> for writing universal PSQL blocks.

If I remember correctly, I uses TABLE.COLUMN%TYPE mostly
for things like:

select customerid
from customers
where ...
into :myvar

Where, of course, myvar is defined as TABLE.COLUMN%TYPE

That way - it's really cool :-)

And of course, if you input a couple of PK columns to a proc,
these kind of parameters would be useful too.

Anyway... It doesn't exist in Fb.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com