Re: [SQL] getting back autonumber just inserted

2005-07-13 Thread Larry Meadors
If you have a trigger on your table that inserts a record in a table and shares the same sequence, what value do you get back, the triggered curval, or the currently inserted one? Being a lazy bum, this is why I still prefer the "get key - insert record" approach. Less brain power required. ;-) L

Re: [SQL] getting back autonumber just inserted

2005-07-13 Thread Larry Meadors
Sounds like M$ SuckQL's @@identity value. ;-) Larry On 7/7/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Fri, Jul 08, 2005 at 01:56:26AM +0200, PFC wrote: > > >Do you mean with lastval()? Here's what happens: > > > > Hm, interesting, you mean the return value of lastval() also depends > > if

[SQL] Looking for info on 8.1 features, and some examples

2005-06-18 Thread Larry Meadors
I am looking at the features for pgsql 8.1 (based on what I read in http://gborg.postgresql.org/project/pljava/projdisplay.php), and am wondering if anyone reading this has a simple example of some procedures that use OUT and INOUT parameters that they would be willing to share... Larry -