Re: [SQL] Question re: serial

2004-04-24 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sat, 24 Apr 2004, Michael Satterwhite wrote: > I have a table with a primary key defined as serial unique. When I insert a > row into the table, I need to get the value of that row back so that I can > use it to link rows in another table to

Re: [SQL] Question re: serial

2004-04-24 Thread Bruno Wolff III
On Sat, Apr 24, 2004 at 12:24:03 -0500, Michael Satterwhite <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I have a table with a primary key defined as serial unique. When I insert a > row into the table, I need to get the value of that row back so that I can

[SQL] Question re: serial

2004-04-24 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a table with a primary key defined as serial unique. When I insert a row into the table, I need to get the value of that row back so that I can use it to link rows in another table to it. How do I do that in Postgresql? I know that I can defi

Re: [SQL] Design Problem...

2004-04-24 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > The problem is that it is possible that the service can be switched to a > different business unit, and then possibly back to the original later on. First, you will get more responses if you do not create a new topic in the middle of an existin

Re: [SQL] Order by YYYY MM DD in reverse chrono order trouble

2004-04-24 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I am trying to select distinct dates and order them in the reverse > chronological order. Although the column type is TIMESTAMP, in this > case I want only , MM, and DD back. If you don't need them separated (which I suspect may be the cas