Peter Eisentraut wrote:
>
> Hannu Krosing writes:
>
> > > > Is there an ISO/ANSI SQL interface to BLOB's defined someplace ?
> > >
> > > It's basically no different from regular character strings, i.e.,
> > > substring(), position(), ||, etc.
> >
> > So no standard seek/read/write type interface ?
>
> SQL is not a procedural language, so this has to be expected.
SQL is about 3-5 languages which share some syntax DDL,DML,DQL,cursor
manipulation,...
And we do currently have seek/read/write for LOs, possibly as a relict
from postquel.
We also have PL/PGSQL and other PL's that can be used from wihin SQL, so
for me the
borders between different languages seem quite blurred.
What I hoped the standard would have is something like cursor ops on a
field in on
outer cursors current record.
------------------
Hannu