Re: [SQL] RE: pl/pgsql and returning rows

2001-03-28 Thread Richard Huxton
From: "Bruce Momjian" <[EMAIL PROTECTED]> > MY book in chapter 18 has a Pl/PgSQL function called change_statename > that does insert/update automatically. > > http://www.postgresql.org/docs/awbook.html The functions called get_details though, so I assumed it's supposed to be shorthand for a joi

Re: [SQL] RE: pl/pgsql and returning rows

2001-03-27 Thread Bruce Momjian
27, 2001 3:52 PM > > To: Jeff Eckermann > > Cc: [EMAIL PROTECTED]; wade > > Subject: Re: [SQL] RE: pl/pgsql and returning rows > > > > MY book in chapter 18 has a Pl/PgSQL function called change_statename > > that does insert/update automatically. > >

Re: [SQL] RE: pl/pgsql and returning rows

2001-03-27 Thread Bruce Momjian
MY book in chapter 18 has a Pl/PgSQL function called change_statename that does insert/update automatically. http://www.postgresql.org/docs/awbook.html > As a workaround, you can insert your row into an existing table, then > retrieve it from there later. I think you need to enumerate a