Subject Re: [firebird-support] Domains as data type in PSQL
Author Martijn Tonies
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
> 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
> 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