Bruce Momjian wrote:
>
> Hiroshi Inoue wrote:
> > Bruce Momjian wrote:
> > >
> > > Peter Eisentraut wrote:
> > > > Bruce Momjian writes:
> > > >
> >
> > I don't understand what you two are discussing.
> > What's is SENSITIVE, INSENSITIVE or ASESNSITIVE ?
>
> In SQL99 standard, I see:
>
> - If the cursor is insensitive, then significant changes are not
> visible.
>
> - If the cursor is sensitive, then significant changes are
> visible.
>
> - If the cursor is asensitive, then the visibility of significant
> changes is implementation-dependent.
While a cursor is open, another application inserted a
row which satisfies the condition to be contained in
the cursor and committed. Then
If the cursor is SENSITIVE, must it see the row ?
If the cursor is INSENSITIVE, it mustn't see the row ?
regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/