Re: [SQL] currval() without specifying the sequence name

2004-03-09 Thread ow
--- Tom Lane <[EMAIL PROTECTED]> wrote: > or that the last one that's touched is the one you want? Correct. __ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com ---(end of broadcast)---

Re: [SQL] currval() without specifying the sequence name

2004-03-09 Thread Tom Lane
ow <[EMAIL PROTECTED]> writes: > I guess I could but then: > 1) I'd still have to know the sequence name. When integrating pgSql > with 3party frameworks I'd either have to pass it there (could be a > very difficult task) or make some assumptions (also not very good). This scenario is really enti

Re: [SQL] currval() without specifying the sequence name

2004-03-09 Thread Richard Huxton
On Tuesday 09 March 2004 13:50, ow wrote: > Hi, > > Is there a way to retrieve the current value (i.e. the last used value) of > the last used sequence without specifying the sequence name? Something like > the following: > > create table ( id serial, value varchar(10)); > insert into someOthertest

Re: [SQL] currval() without specifying the sequence name

2004-03-09 Thread Achilleus Mantzios
O kyrios ow egrapse stis Mar 9, 2004 : > > --- Achilleus Mantzios <[EMAIL PROTECTED]> wrote: > > > > You could use the same sequence in many tables. > > > > I guess I could but then: > > 1) I'd still have to know the sequence name. When integrating pgSql with 3party > frameworks I'd either ha

Re: [SQL] currval() without specifying the sequence name

2004-03-09 Thread ow
--- Achilleus Mantzios <[EMAIL PROTECTED]> wrote: > > You could use the same sequence in many tables. > I guess I could but then: 1) I'd still have to know the sequence name. When integrating pgSql with 3party frameworks I'd either have to pass it there (could be a very difficult task) or make

Re: [SQL] currval() without specifying the sequence name

2004-03-09 Thread Achilleus Mantzios
O kyrios ow egrapse stis Mar 9, 2004 : > Hi, > > Is there a way to retrieve the current value (i.e. the last used value) of the > last used sequence without specifying the sequence name? Something like the > following: > > create table ( id serial, value varchar(10)); > insert into someOthertest