From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Thomas Swan <tswan(at)olemiss(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Re: 7.2 items |
Date: | 2001-06-28 06:33:24 |
Message-ID: | 3B3ACFB4.55098A7C@tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2001-06-28 07:41:11 | Re: functions returning records |
Previous Message | Alex Pilosov | 2001-06-28 01:24:09 | Re: functions returning records |