Number of Columns in a raw

View: New views
2 Messages — Rating Filter:   Alert me  

Number of Columns in a raw

by Nelli Vanan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi there,

I am new to this, so please bear with me if I am not making any sense.
  I am working on an application that
requires database to notify of any changes in the table.  I have
successfully experimented with basic triggers.

What I want is to receive the complete row when something is changed
on that row.
For example in a table with three columns( ID, name, value), I want to
receive the entire row when any one of the
three columns changes.  From the example I tried out, it appears that
I would only get the changed column.  Is it true?

Thanks so much for your help.
_______________________________________________
Pljava-dev mailing list
Pljava-dev@...
http://pgfoundry.org/mailman/listinfo/pljava-dev

Re: Number of Columns in a raw

by Nelli Vanan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ok.  I had to do a bit reading before I post something here, I think.
ResultSet would have all the data I wanted.

On Wed, Oct 22, 2008 at 1:51 PM, Nelli Vanan <ambulimama@...> wrote:

> Hi there,
>
> I am new to this, so please bear with me if I am not making any sense.
>  I am working on an application that
> requires database to notify of any changes in the table.  I have
> successfully experimented with basic triggers.
>
> What I want is to receive the complete row when something is changed
> on that row.
> For example in a table with three columns( ID, name, value), I want to
> receive the entire row when any one of the
> three columns changes.  From the example I tried out, it appears that
> I would only get the changed column.  Is it true?
>
> Thanks so much for your help.
>
_______________________________________________
Pljava-dev mailing list
Pljava-dev@...
http://pgfoundry.org/mailman/listinfo/pljava-dev